Discussion Categories

Hello, I am unable to save to data store using write to multiple DS smart service. For the context, I am trying to save data to 10 tables at once.

How to group the reports in Tempo Reports tab. Need to create links in left panel and based on the selection, list of reports should display in the right panel. Please let me know

Hi Guys! I have this expression rule: {   a!update(  data: ri!holder.name,   index: local!indexValue,   value: "test"   ) ),   a!update(   data: ri!holder.age,   index: local!indexValue,   value: 23   ) ),   a!update(   data: ri!holder.married,   index: local!indexValue,   value: true()     )   )} This is my current process to update the CDT value of ri!holder.name, ri!holder.age, and ri!holder.marriedMy CDT holder contains: name(array of text), age(array of number), married(array of boolean). Expected ouput should be:[name="test",age=23married=TRUE] However Im getting a List of variant where all the values are stored in ri!holder.name:[name="test";20;TRUE] Do you have any ideas or suggestion on how to get the expected output?Thank You!

Hi I am trying to save data in the Appian database through CSV  not getting any exceptions in the process model but not able to save data. Can you please help me out? Do we have to config in the output tab also?

What's the difference between thingworx composer and Appian?

Hello Team, Please, do you know of a command in linux that can help grant a user account read,write,execute when configuring a linux box. When installing appian, I keep getting permission issues when executing the search server. Is there a way to fully grant a user full permission to a folder and sub folders in Appian - Linux? Thanks error when using root account: Future versions of Elasticsearch will require Java 11; your Java version from [/home/appian/java/jre] does not meet this requirement. Consider switching to a distribution of Elasticsearch with a bundled JDK. If you are already using a distribution with a bundled JDK, ensure the JAVA_HOME environment variable is not set.warning: no-jdk distributions that do not bundle a JDK are deprecated and will be removed in a future releasewarning: usage of JAVA_HOME is deprecated, use ES_JAVA_HOMEFuture versions of Elasticsearch will require Java 11; your Java version from [/home/appian/java/jre] does not meet this requirement. Consider s

i created the editable grid, using that i want to send the data to the DB but my requirement is like with out using the Process model witch function i need to use in the interface,also if i delete the data from editable grid(in interface) it will reflect on the DB(with out using the Process Model) for that witch function i need to use in interface

Hi folks, I need Audit multiple database tables by using creation of generic stored procedure. Could you please help me on this? Thank you.

Hello! I have a problem of following type: a!localVariables( local!emptyArray: {}, ... { ... a!forEach( ... a!localVariables( local!variableWhichChangesWithEveryIteration:{...}, { /* Here I want to append the local variable's value to my empty array. Something like this: */ a!save(local!emptyArray, append(local!emptyArray, local!variableWhichChangesWithEveryIteration)) } ) ) /* my array will be used here */ } ) The problem is that value of the array won't refresh by itself (if I use saveInto in a textField, for example) and I don't know how to do it automatically...

Hello,  Is there any workaround using Create User Smart Service.  Non Administrator User to be able to create new users ?

Hi All, On gridRowLayout selection i am populating the selected grid data in local!selectedGridData which has the clientID value for selected row. From this local!selectedGridData, we need to update the clientID value to ri!clientDetails.clientID at selected index on click on button. Here local!selectedGridData and ri!clientDetails both are of array. Please help with sample code, so that i will try once. Thanking you

Hi!   We are currently passing in a folderId over a WebAPI call to Appian - from there we are using a!startProcess to run the Document Zipper smart service to zip the folder and output the resulting documentId. Is there a way to allow the resulting zip document to be downloaded via the WebAPI call, or will I have to use some workaround like using an additional GET method to pull the document after using POST to run the smart service? Thanks!

Hi, Can Someone help in writing a&nbsp;rule which gives me a list of users whose last login date was a year back. I wrote this rule but it is pulling users with the lastlogin date as null.&nbsp;Please correct me a!forEach( expression: if(todatetime(getuserlastlogin(fv!item)) < ri!datetime,fv!item,""), items: getdistinctusers(cons!PDS_USERS_TYPE) ) Thanks in Advance

What are the challenges You people faced while developing ? How did you resolved it?

Hi All, How to enable the dropdown field based on gridLayout selection? actually i am trying with the below code but it is not working as expected: Please help and suggest logic so that i will try to test it. a!gridLayout( headerCells: { a!gridLayoutHeaderCell(label: "Dropdown") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE") }, rows: { a!forEach( items: ri!data, expression: a!gridrowLayout( contents: { a!dropDownField( disabled: if( and( rule!APN_isNotEmpty(ri!selectedid), contains(fv!item.gfcid, ri!selectedid) ), false, true ) ) } ) ) } )

Hi All Good morning! Can you please let me know if anyone has used the&nbsp;&nbsp;googleGanttChartField or timelinechartfield plugin in Appian to create a gantt chart using dynamic data, (i.e) data from a record type. If so , can you please providing the guidance or a sample code snippet to configure the same ? Thanks for your help! Regards Soniya PS

What would be a good way to aggregate data records (or data record types) to display in a list? Appian supports the aggregation of record types in charts - I wonder if there is an easy way to display aggegration results in tables.

I have requirement That One question with multiple answers using poll option Can we do polling in Appian. Thanks, Divya

We are attempting to create an SSIS package for our on-premise MSSQL Database to&nbsp;create a connection to the Appian Cloud Maria DB. Is it possible to create an ODBC connection to facilitate this integration? Unfortunately, we cannot utilize the built in Connected System for integrating MSSQL due to&nbsp;our VPN being outbound only.&nbsp; Thanks!

Just Installed Appian on Linux (Centos) But the site is not redirecting to /suite page. What am I missing? I get the error below when I load the site Any help will be appreciated. Thanks

Hey guys! is there any way to make this cleaner? I have to many OR and probably there is a better way to do this, so what i need is: &nbsp;OR to go to a path in case it finds a status or the other one if it doesn&#39;t find it then i need that in both cases it goes back to the script contador that its just an index+1 and iterates

I encounter with the question &quot;join performs on 3 table and each table has many rows and queries, it returns many responses&quot;. live data not required and 2 hours refresh allowed?? which option we use and why?? options:--store procedures or materialized view

Just Installed Appian on Linux (Centos) But the site is not redirecting to /suite page. What am I missing? I get the error below when I load the site Any help will be appreciated. Thanks

my data is storing in the data base in the formate of customer number :&quot;F123&quot;&nbsp; i have serch filter when i search with F123 it is returing the related data but now if i search with customer number with padding (0) like &quot;F000123&quot; it shoud return the data whic have returen for &quot;F123&quot;, the customer number is passing to stored proc and getting the out put so my queery is before sending input to the stored proc i need to remove the padded values then need to send to stored proc please me with solution&nbsp; so how can i remove the padded (0) from the value where i am searching

Is There Any Smart Service For Download DDL scripts In Appian