-
Recently active
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,.,.....)
Is there a way to display the user input in different color instead of black inside the editable textField or paragraph while typing?
Hi! We would like to connect to IBM MQ 9.0.5. In the market it used to be a plugin for this, but I can’t find it anymore. Isn’t it working anymore? I would like to check if it works with IBM MQ 9.0.5 since we have to use a new cipher only supported in the version or a newer one. Furthermore, in the documentation it is mentioned the following: JMS configuration is not supported on Appian Cloud. If you need to integrate with JMS on your Appian Cloud site, you can achieve most JMS use cases via a plugin https://docs.appian.com/suite/help/21.4/Working_with_the_Java_Messaging_Service.html#see-also ¿Which one could be the correct plugin to be used? Thanks to the community!
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.
There is a requirement where i have to insert nested CDT(one to many) data into table and then read in another process model. Parent CDT : policyDetails policynumber customerId actiontype nomineeDetails Child CDT= nomineeDetails { title: "Mr", forename: "abc", surname: "Test One", dateOfBirth: "01/01/2000", percentage: 80, relationship: "Brother", addressLine1: "Hall Road" } { title: "Mr",forename: "xyz",surname: "Test two",dateOfBirth: "01/01/2006",percentage: 50,relationship: "sister",addressLine1: "aaaaa", } My Approach : Create two tables policyDetails & nomineeDetails with foreign key = policynumber Insert policy details into first tables without nomineedetails. Insert nominee details into second table using MNI in process model. Create 2 expression rules to read data from both tables and use it. Do you guys feel that there should be be
Hi, I have a database table called "Status" along with a CDT in Appian with the below list of values. Also, I have an employee table with statuskey reference along with a CDT and while adding an employee using employee - add interface, I am saving the status as "1" (default). Also employee table is having loggedInDate. statuskey status 1 Active 2 Inactive 3 Terminate Can someone suggest what need to be done if I have to implement below requirement. I have to mark the employee as “Terminate” if the employee is in inactive status for 30 days. I have to mark the employee as “Inactive” if the employee is in active status for 15 days but not logged in(By looking into loggedInDate.
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:
Hi all, This is my uses case. I have a reference table with 2 columns (id(PK) and description) with all the possible statuses: 1 - Ongoing; 2 - Completed, ..... I need to insert an entity case, that it has a FK to that statuses. For instance, idCase = 1, idStatus = 1. So my question is, what is the best approach to map the value (Ongoing, Completed, ...) into my case CDT? My initial approach is to have a CONSTANT with the status values: "Ongoing", "Completed" and get the id by a query rule to the table status. Thanks in advance.
Hello Community: This probably a dumb question but here is my dilemma. I have two tables 'Consolidated Product List' and 'Brand Owners' (fields: brandIdentifier, brandOwner). The field 'brandIdentifier' in Brand Owner is the foreign-key in 'Consolidated Product List'. I am trying to populate a grid with brandOwner for each product in 'Consolidated Product List' but having a heck of time display the brandOwner. Here are images of my query, my interface, and my debugging screens. Any help would be appreciated. Ma
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?
Hi, I am fileUploadField() to uploaded the document in a specific folder and saving the documentId in the database under one of the field/column. When I try to perform delete functionality against the database record, I am using "Delete from Data Store Entities" smart service. When I delete a database record, I would like to delete the corresponding document which is linked to the database record. How can I achieve this. Any advises please. Thanks.
Hi, is there a way to task record unsupported element in RPA.
how can i integrate outlook with appian. my use case is i want the emails from my outlook inbox to be in appin. where i can store it in db. almost tried all the connected system and plugins. kindly someone help me out.
Hi Folks, I need little help. I want to handle my outlook mailbox via Appian for incoming emails and for replies with & without attachments. Can someone suggest me the solution because I am unable to find the right connected system for Microsoft 365 & appian. Evenly there is no plugin option available for this.
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 ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.