Discussion Categories

Hi All, I am getting this error , while retrieving the data form db by using queryEntity  I have verified my datastore and it's also giving an error can anyone please help on it ! Regards, Supriya

Hello Community, I was wondering how do you capture the process property ID when the process is submitted to then use it in a link within that interface. a!processTaskLink( label: "Approval Task", task: 1 /* pp!id */ ) Thank you.

how to show a confirmation message when performing action by using dynamic link?

Hi All, We have a Use Case in which we need to do the excel header validation for the Excel File which is having 358 columns and 12000 rows of data. When we tried to execute the below code: fn!readexcelsheetpaging( exceldocument: ri!excelFile, sheetNumber: 0, numberOfColumns: 358, paginginfo:a!pagingInfo( startIndex: 1, batchSize: 1, sort: null ) Output : It is not returning any data for 12000 rows, however it is working for max 8000 rows in excel file. Do anyone has faced same issue or error ?

The Appian Product Management team is prioritizing ways to make application design more efficient. Please consider helping that effort by taking this brief survey so we can learn more about which recent features have made your development faster and what is still slowing you down.

i want configure link field in submit button or button layout, how can i achieve  this

Hi All, I received the below error email and also saw the error when I opened my record, I checked the sync history of the respective record, it shows the below message, When I checked the particular process, it is completed successfully - this process deletes the data for the particular task(on click of cancel in front end UI by user) from all tables including the table used for this record. This issue is automatically resolved after few minutes, but the business saw this error when they opened the record, so they are asking for the justification which I am not getting what to do here. I can see ,they have canceled many task(10 task approx. ) ,then they created a new task, cancel will trigger the process model which deletes the data from DB, So I am wondering here ,in Database at the same time if we do delete as well as write new data then it will fail during immediate sync? Could you please help me to find out the root cause of this issue .Thanks in Advance !

Hi Team, I want to connect to an Oracle 19c Cloud Free Database. I have tried configuring it in the Admin Console >> Data Sources. But no luck, Can some one help with a sample connection string  for cloud connectivity ? Also let me know if i need to enable anything from the cloud side, for now am able to connect SQL Developer with the cloud wallet file. Thanks, Sunil Mohan

I want add a color and text style to add row dynamic link label using in editable grid . how can i change the color ?

Hello,, using v22.3, there seems to be a limit of 10 documents that can be added to application documentation. Is this a configuration setting or simply a hardcoded value.

I'm passing multiple values in fields above except id (Id field is emoty as i have cofigured in cdt as autogenerate),Like paasing a code in userId which returns {2,2,2,2}code in product id returns {1,2,3,4}code in userProduct quantity returns {100,55,68,75}code in total price returns {100,230,45,67} isactive is trueCan you help me what is the issue here?

I want to design a interface with couple of links, when I click each link, I need to display related options of hyperlinks. Finally If I select one it shd navigate to specific interface. Any sample code for this

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