Foundation

I'm creating an Appian web API to retrieve documents from our Appian system and link them with our other systems. To that end, I'm utilising Appian's folder() function to gather information about the contents of a folder. folder( theCaseFolder, "documentChildren" ) The issue I'm facing is that, while this code works most of the time, we have some instances with over 1000 documents recorded against the case. I notice in the Appian documentation that: The documentChildren and folderChildren properties provide the top 1000 documents or folders that are direct offspring of the specified folder, accordingly. My issue is that we have a few cases where there are over 3000 papers attached. Is it possible to obtain a list of those kid documents, or am I completely out of luck?

Hi: I was trying to learn about web-integration using the credit card integration example (https://docs.appian.com/suite/help/23.1/Integration_Tutorial.html) and the currency function in the interface doesn't seem to be working - Error:Expression evaluation error at function a!currency: The function a!currency is unavailable. I tried the basic example from the a!currency documentation page (https://docs.appian.com/suite/help/23.1/fnc_text_currency.html) and it gives the same error.  a!currency( isoCode: "USD", value: 1234.56) Looked to determine if this function is old - but it seems to be part of 23.1 release.  Any ideas of what is going on?  When it might be available?  Or is this not available in the community edition? Thank you! Ma

Good Day Experts, Can anyone please help me how to configure/use the password encryption for Fitnesse for Appian ? We can configure the user name and password in the user.property file and we can use as a RULE in fitnesse script but I'm not looking for that. We wanted to use the encrypted username and password (at least password ). I've gone through below documentation but still I'm not  able to figure out. http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordCipher Please let me know if you need more details. Thanks in advance. Cheers, Kalai.

Hi Team, Getting below error while trying to open downloaded document from Appian after merging with smart service DOCX Merge: Error: Word found unreadable content in "test 1.docx". Do you want to recover the contents of this document? If you trust the source of this document, click Yes. Regards,Sandeep

I want to run a Dynamic "Select" Statement in Oracle DB.  So used a SYS_REFCURSOR output variable and used "OPEN FOR" Statement to execute it. While executing this stored procedure I got this following error  Any suggestions or ideas would be greatly appreciated.Thank you ahead of time.

Hello, everyone. First of all: I'm new to Appian. I have several very complex views in a PostgreSQL database that I want to replace in some way with intermediary appian objects that allow me to build the views logic step by step. Is there a way to build some kind of record type that has in-built logic from other record types or data store entities? Is there a way to call the result of some query from within another query and to call any of those from an interface?

Is there any fast way to check if i have any of this functions in my app? Currency functions The following functions related to currency localization are deprecated and will be removed in a future release: dollar() euro() pound() yen() Calendar add functions The following functions related to date and time addition are deprecated and will be removed in a future release: caladddays() caladdhours() And also how can I check if this affects me? thank you!

Hi, inside an interface I have a safelink to download a document pdf from external system (Neoshare) with a safe uri. When I clcik the link the download starts but the file downloaded remains with the temporary name "not completed XXXX.crdownload" and the file is not usable. (XXXX numeric). The same link in the url of the borwser works fine, the pdf file is downloaded. What could it be the issue? thanks

Trying to create a group using smart service through a process model. However the group is getting created but the following groups are not showing not in the application. Also inherited to the administrator access parent process, security is correctly mapped as expected. If anyone through some light.

Hello Community, We have a form that we modify to bring in all of our interfaces.  Most of them pull json from a REST api. This interface will need to GET and UPDATE methods from a SQL table and will trigger off of the process ID. Expression: takes 2 inputs: the current process id and a key that will allow me to pull specific data out of the json. My Question:  How do I pass the forms process ID into the expression?  Here is the start of my rule to pull in the interface into the form: rule!TEST_ReviewsList(rule!CORE_GetProcessDataByKey(wfProcessId: "47" , key: "comment")) Thanks,David

Hi, I have defined a local variable inside interface in which i am updating value of rule input like local!item: ri!data, Now I created one expression rule inside that i am writing multiple validations, in this expression rule inside rule input I am passing local! items from interface and I am calling this expression rule on save button for disable it, but it is not working. Note: local!items value is getting updated in interface while changing row value in grid.

Hi everyone, I'm having this issue where I'm trying to index a date and time array using the index of caseID from another array with same order. Below are the process variables and the code that I wrote: allCases Number (Integer) 3,061,158; 3,061,157; 3,061,156; 3,061,155; 30,611,111; 306,115,555 updatedDateTime Date and Time 20 May 2023 12:00; 21 May 2023 12:00; 20 Jun 2023 12:00; 6 Dec 2023 12:00; 20 May 2023 12:00; 20 May 2023 12:00 However there was no updatedDateTime value passed into my sub-process, so I'm wondering what did I do wrong with the indexing. Any idea? Thanks a lot in advance :)

when user upload any kind of excel sheet then interface will extract data and show the user the data. I have created a Expression rule  readexcelsheetpaging(excelDocument : todocument(ri!ExtratExcel), sheetNumber : 0,pagingInfo:a!pagingInfo(startIndex:1,batchSize:1000),) but don't know how to add it in script task and make process model out from this.

We can do Numerical rating in appian , Is it possible to create a Decimal rating like , on click of star once (0.5,1,1.5,.,.....)

Is there a way to display the user input in different color instead of black inside the editable textField or paragraph while typing?

Any thoughts on how we can handle this problem?Did anyone else faced similar issue and how did you handled it? Many times recently we have cases that get "stuck" are doing so because someone processes on them twice. There's three flavors of this: The same user opens the case on two different tabs/windows. They process the case on one and a few hours later process the case again because they found the second tab Two users open the case. User 1 processes and completes. User 2 then does the same a few minutes later [only seen twice] Two users hit get work within milliseconds of each other and got the same work object We're less concerned with option 3 because we've only seen it once. Options 1 and 2, though, are painful.  Could  we change those process models to prevent this issue: We want to include clear messaging to the user when they try and process the second time. Consider performance too.

Hi, when i edited one row data and submitted after that second row is not getting selected means after selecting first row the local variables selected row and selected row index has the value 1 after submitting it it was nullified when i am selecting the second row the local variables not taking value to edit. please find the below screenshot for the same and suggest on this. After selecting first row: After submitting first row and selecting second row:

In Appian RPA , there it is not showing Resource Tab. How to locate it ?

I am trying to save data using Rich Text Editor having longtext Data Type. But when I check the record type for the saved data, the full data is not showing up, only 40% data is showing up in record. What can be the possible reasons for it?

I have created a local variable that will fetch all the tasks from a process report. When there is a change in  the task,i.e. i have accepted or assigned or completed the task, or added a new task, it should automatically refresh the grid and show the change in it. How to do this process?

in the expression the time value shows in EDT, but the zone display as GMT+00:00. how can I change this ?

as i have written the following code .. but how to increase the index.. iif user clicks on add new .. new field of mobile number should get added..a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!forEach(items: local!npi,expression: a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: fv!item, saveInto: fv!item, validations: if( a!isNullOrEmpty(fv!item), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", fv!item) ), "Maximum " & 10 & " digits are allowed", "" ) ) )) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dynamicLink( label: "Add New", value: { local!npi + 1

Need to add multiple phone numbers.. on screen  and want to store in DB .. what could be the best approach

Hi All, I have updated a CDT and table by adding a new column and deployed those changes to PROD. Now I have couple of active process instance of each request in PROD which is using old CDT version and I need to fill new column with a specific value as per customer request. Since we have " write to data store entity" smart service in active process instance, even though if i try to update backend table directly to update that specific column for each request, the column value changes to Null when process moves forward(Specifically after "Write to DS entity"). Please suggest an approach to resolve this issue. Thanks in advance

how should i approach from appian side ... to add mobile number dynamically .. For now i am having  blank text field where user can enter mobile number.. next to it i want to provide add button .. so whenever it gets clicked a new text field should appear to add new mobile number with validation ... a!localVariables( local!add , local!npi, a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( label: "Mobile Number", labelPosition: "ABOVE", value: local!npi, saveInto: local!npi, validations: if( a!isNullOrEmpty(local!npi), {}, if( not( regexmatch("^([0-9]{" & 10 & "})$", local!npi) ), "Maximum " & 10 & " digits are allowed", "" ) ) ) ), a!sideBySideItem( item: a!linkField( label: "", links: { a!dyna