Discussion Categories

Hi: I was experimenting with the Grid example in Appian Tutorials (https://docs.appian.com/suite/help/23.1/Grid_Tutorial.html) and noticed that I had some rows with no firstName and LastName.  So, I thought I would use "fv!row.firstName" as part of the showWhen-attribute to prevent those rows from being show (see image below).  However, I am getting "scoping error" messages.  I know I can use query to filter out those rows but thought I would experiment with this approach because I have had issues with understanding local-variable scoping.  For example, when I use {} right after a!localVariables (), I get scoping error (see second image.  Any responses to helping me understand local-variables/scoping would be appreciated. Thank you. Ma

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 have created a MNI in a user Input task  In the assignment Tab, set the assignment to one to one as well The above group contains two users. But as soon as one user completes the task, whatever the data filled by that user is showing to the other user as well.  Could you please help me to resolve this error

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.

Can someone list out the pros & cons of Compare & Deploy functionality Appian provides. And What could be the reason one should go with separate outside Automate process of Deployment for e.g Export Package and Update into Repo and move along in upper environment via DevOPS tools and if there is any Database change then also use Repo to upload and then Move along with Jenkin Build and other tools.

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

Hi , I am trying to upload an excel file from my local desktop to Appian folder.  I am using upload document action from Appian RPA. I am able to locate the file and get file properties but facing null pointer issue when trying to upload the file to Appian folder. Please refer to the execution log below. Any insights on this would be helpful.  [WARN] 2023-03-09 19:19:40 - - Method manageException invoked[ERROR] 2023-03-09 19:19:40 - - java.lang.reflect.InvocationTargetException    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119)    at java.base/java.lang.reflect.Method.invoke(Method.java:577)    at com.novayre.jidoka.client.RobotClientExecutor.invokeMethod(RobotClientExecutor.java:1546)    at com.novayre.jidoka.client.RobotClientExecutor.onManageExceptionMethodCall(RobotClientExecutor.java:778)    at com.novayre.jidoka.cli

Hi there,  We are OAuth 2.0 code grant flow to connect to an system. We want a functionality where we can have a logout button which will remove the auth token for that particular user.

Hi , we are using this plug-in for signing PDF document with corporate certificate (pfx). My question is how to make certificate trusted without doing anything on client side (Adobe Reader )? BR,Natasa

Hi. I'm working through the Appian Developer course online, and I'm stuck on something in the Appian Step-by-Step #10. Specifically the first task, Configure Process Properties. The guide tells me to "Click the Expression Editor icon next to the Process Display Name field... Before you use this expression rule, open the rule in a new tab... Once the expression rule is open, change the name of the record rule input to vehicle. Click Save Changes." I did that:  I returned to the process model, as instructed, and in the expression, I deleted "record: pv!record" and replaced it with "vehicle: pv!vehicle". But when I went to the Process Start Form tab to make sure the rule inputs and values for the interface were "vehicle" and "cancel", the input I had changed form "record" to "vehicle" still showed up as "record" (I also changed the value to vehicle from... whatever it was; I do

Hi Team ,  We trying to migrate few application from cloud to On-premise . While deployment , we found "Zip Extractor" has dependency. We couldn't able to find it in the APP market . The plug-in has the smart service - Extract the ZIP file. Need guidance on how to proceed on this ?

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 all, I'm following the tutorial RPA Tutorial: Parse Excel Files to learn how to retrieve files from a resource. From this example, I'm using my pc as resource. In one speficic documentation steps, there is the note If you’re using your own desktop as your resource, do not use your mouse or keyboard while the test is running. So, when I launch  the robotic process, I don't touch my mouse or my keyboard. So, system gives me the expected results for file properties, but, when I move the mouse, to read it, it appears a pop up with a message error. I try however to configure the process and I receive another error with request status ENQUEUED. Which could the problem be?  Thanks in advance. Regard, Juri Monti

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, I have below rule which gives output for distinct values only, but I want get output for indistinct values also. For Ex: If I give rule input for groupId_int as {496,496,498} , I should get output for all 3 values though it repeats for 496 two times. But here I'm getting only for 2 items as below screen shot. Can anyone please help me how to approach  index( a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_APPIAN_GROUPS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "Id_int", operator: "in", value: ri!groupId_int, applyWhen: not( rule!APN_isBlank( ri!groupId_int ) ) ), a!queryFilter( field: "groupName_txt", operator: "in", value: ri!groupName_txt, applyWhen: not( rule!APN_isBlan

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 :)

Hello Folks: I am trying to figure out why the "value: ......." works when I use fv!identifier but fails when I use fv!row (this gives me all 14 values as the output) whereas I am looking for just the current grid-row's value (one value).  The gridfied documentation seem to imply both are equi As usual, thanks to the community on my Appian learning journey. Ma

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.

Is there a way to create application and add provided artifacts into it on Appian using Process model or some other mechanism. Problem statement : Create Backup application from higher environemtn with provided artifacts added into the created applicaiton. export it before code promotion 

Hi, I have a process model that generates a document, and the id of the document gets stored in the process variable. Now in my interface I want to call this integration and extract the document ID so that I can provide it for the document download link function for the user to download the document. Now the problem is I am unable to access the result of the integration. I tried accessing the id using 'rule!integrationRuleName.body.id' but it constantly gave me an error saying cannot index property body of reaction tree. Can anyone help me in this, how to extract the document ID from the integration result ?  

Scenario is need to filter the data based upon user access to certain business unit id,forum id.Business unit id's are different sectors of business and they are mapped to certain forum id's.Business unit can have duplicate forum id's. they are stored in table like  user id bu id forum id 117 4 80 117 4 103 117 4 114 117 19 80 19 also has records with 103,114 forum id but we need records on the above mapping but when we try to filter it out by querying and storing in a local variable not able to filter out records for mapping of(19-114,19-103). local!buid(filter:userid), local!forumid(filter:userid,buid), In a interface we are using a record type in data and in filter we are using logical expressions.

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,.,.....)