General

can we declare  local variables inside a!foreach() inside expression rule 

Hi Team, I have group - Group1 In the group 1, we have 3 users user1, user2, and user3. Now, I have loggedin with user1 account. In the pickerField now the user1 should not be listed out. Can you please help with the approach.  a!pickerFieldUsers( label: "Users", labelPosition: "JUSTIFIED", maxSelections: 5, groupFilter: cons!Group1, value: local!selectedApprovers, saveInto: local!selectedApprovers, required: true(), validations: {} )

Hi, I am trying to get the next day from today's date. For eg: today is 18/9/2023. I need to get 19/09/2023. I tried using some day function to get the day and add 1 to it. I was testing with different timezones. now() - 9/18/2023 10:50 PM PDT now() + 1 - 9/19/2023 10:50 PM PDTwhen I used day function on now() +1, its giving 20 instead of 19. I am not sure what is the issue or maybe I am missing some timezone offset. This is occuring when I tested for Pacific timezone. Its working fine for IST. Please help me on this. a!localVariables( local!date: now(), local!endDate: now()+1, local!day: day(local!endDate), local!day )

Greetings to all the Appianites out there! I have a client organization who adopted Appian, over a decade ago, to build one application in its own data center. They didn't keep up with the product upgrade (like any undisciplined DIY jobs). The application is now wrought with all kinds of issues and the stakeholders is second guessing Appian and contemplating changing horses, though I believe a more sensable approach is just to rebuild the app on latest version of Appian on Managed Cloud.  To convince the client to stay with Appian, some facts on the revolutionary Appian product improvements could be super helpful. I started my Appian journey only about 5 years ago. Hence I have little knowledge of what it might feel like working with decade plus old Appian platform. Would be grateful if anyone care to share his/her perspectives, traveling down the memory lane of Appian product evolvement.

When you and your colleague are working on the same expression rule, you need to have a common test case to be used for both of you, what will you do?? Select multiple actions required[Multiple Choice][a] Create Test case[b] Add it to a testing group[c] Use Ad-hoc Test Cases[d] Create a new testing Expression Rule

I have below record Data {'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':3, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11107, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110604, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':4, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11108, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110605, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':5, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11109, 'recordType!PRO Lead Documents.fields.

I have a parent Interface calling 2 child interfaces. Both the child interfaces are grids.  The first grid shows previously added data and has capability to select a row and add it to the bottom grid using Select button. The second grid has search fields to search for an item and add it to the grid. I'm passing these 2 different data as 2 different variables to the Grid 2. (Though I tried passing as single didn't work). Here is my scenario:   I select first item from Grid1 it gets added to the Grid 2 Then I search functionality and add data to Grid 2 Now I select another item from Grid1 and try to add. Problem: This time when I select my second item from Grid 1, I don't see the newly added item in Grid 2. I see the newly added item is seen in local!submissionSubstance_HTTP but not in the Gri 2 This is the local for my Grid 1 selection local!submissionSubstance_HTTP: a!refreshVariable( value:rule!DCC_castSubmissionSubstanceData( s

We have freeform paragraph field, where user can enter any text string except the emojis. I have tried some of following regexreplaceall function which works fine to remove emojis but it also removes some of the special chars as well. Any suggestion on how to just eliminate emojis by completely removing it or just replace it with text string. input: "afs saf [emoticon:4191f5ee34e248a29fa0dbe8d975f74a][emoticon:5ced9b85a4a246058e4772ef2b9956f4][emoticon:33306c418930400bac28808410f8ac8b][emoticon:ac85b29e2ff049dd9278224b337cdf43][emoticon:ccfc0979d5bf49dc92a54d454ae8fe68] sdfa sdf___~!@#$%^&*()_+{}|:<>?" Function:  regexreplaceall("[^\u1F600-\u1F6FF\s]", ri!input, "" ) currentOutput: "afssafsdfasdf___~@^_{}|:<>?" desireOutput: "afs saf  sdfa sdf___~!@#$%^&*()_+{}|:<>?" Thanks! Ajay

a!forEach( items: ri!pdmDocuments, expression: a!update( ri!DocumentDetails, { 'recordType!PRO Lead Documents.fields.pdmDocumentId', 'recordType!PRO Lead Documents.fields.updatedBy', 'recordType!PRO Lead Documents.fields.updatedDt', }, { index(fv!item,'recordType!PDM Document.fields.documentId',{}),loggedInUser(),now()})), input ri!pdmDocument is {110407,110408}, input ri!DocumentDetails is  List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6699(Number (Integer))wor

Hi is there any function as if i change the count to 2 in list item of 4 it should return only 2 items..as shown below this is list of record type ... now based on count i want to retrive items.. like if count is 2 it should give me first 2  list of record types shown below from 4 . List of PRO Lead Documents - 2 itemsPRO Lead DocumentsleadId6699(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedBy:"test@scar.com"(Text)documentId:110444(Number (Integer))documentName:"_Test_Contract_2_"(Text)updatedDt:9/14/2023 2:49 AM EDT(Date and Time)leadDocumentLookupRefId:278(Number (Integer))createdDt:9/14/2023 2:49 AM EDT(Date and Time)description:""(Text) PRO Lead Documents leadId:6693(Number (Integer))workItemId:31206(Number (Integer))createdBy:"test@scar.com"(Text)workItemFolderId:110429(Number (Integer))isActive:true(Boolean)updatedB

Dear Forum users, How can we know the appian generated custom mobile application is compatible with which version of android and what is the Api level of the apk file.

Hi, is it possible to have 2 eventlogs loaded and connected with each other in Process Mining? Following use case:  - eventlog A with activites for a customer order as case ID - eventlog B with activities for a customer shipment as case ID It is a 1:n relationship between customer order and customer shipments. I can analyse each eventlog seperatly but as they are connected in real life, is there a way to connect them within Process Mining and analyse them?  Thanks for a reply Himanshu

Hi, I have an requirement to trigger appian rpa based on email body content to download file

I have a use use case, when any developer uploads their package in one interface  and that should go through the XML code and return if any objects in that package are using any deprecated functions. To achieve that , is there any function that would read the XML file

.

I have an HttpResponse type pv holding following value: [statusLine=HTTP/1.1 500 Internal Server Error, statusCode=500, headers=[object Object], contentType=application/json, body={"type":""title":"Internal">www.w3.org/.../rfc2616-sec10.html","title":"Internal Server Error","status":500,"detail":"Error connecting to underlying system","instance":"XXXXX/error/uuid:XXXXxXXXXXXXXXX"}] I am passing it to and expression rule and indexing "body" into a local variable responseBody , which is wprking ok, However when I try to index any of the attributes within body , such as "title", "type","detail","status", Index is not working and returning default value. I am trying as follows: errorDescription: if(ri!success,"",if(a!isNullOrEmpty(local!responseBody),"",index(local!responseBody,"type",""))

Hi Team, I am given a task to create users in Production. There is an account already existing in Production which I have to use as a mirror account. The mirror account is a part of lot of groups, and I have to enter these users in each of them. Is there an easier way to do this? Since it is production environment, I cannot use any smart service directly without approval from higher mgmt.  Any help is appreciated. Thanks, Ritika

Do we have any process model/plugins to capture basic fields for field level audit - property that changed , old Value, new Value, last updated by, last updated on

Hi Everyone, The requirement is - There will be a keyword and we have to search for that predefined keyword within a PDF file uploaded by the end user. If the keyword is not there within the file then prompt the user. Please let me know if it is doable. Do I need any plugin?. Thank you

Hi  So basically, i have a record type for " Requests" and i have another record type for "Documents ", In the "Add or Create Request" Interface, which was generated by record action, I should include a section for "Adding Documents", except that adding a document should be done by an editable grid and not record action.  I have the following code for the document editable grid, but when i link it to the document error I keep getting the error shown in the image below.  what is the right way to link the editable grid to the document record type?  ,  a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(label: "Uploaded By" ), a!gridLayoutHeaderCell(label: "Uploaded On" )

i have a requirement  where i'll be selecting the checkbox and once i select the checkbox need to show the show data link, when i click that ink some data to be displayed at right side for the same selected checkbox now what is happening is when i select next check box the show data link is not coming.  can anyone help me to work on this - when i select single check box the show data should come and one i click on that right side some data to be shown. when i select multiple checkbox only latest selected checkbox has to be have show data linka!localVariables( local!limitSelection_cdt: rule!CR_SF_QE_getLimitSelectionData( cif_int: ri!cif_int, requestId_int: ri!requestId_int ), local!limitsList: index( local!limitSelection_cdt, "limitId_txt", {} ), local!showLimitData: false(), { rule!CR_SC_SF_customerDetails( cif_int: ri!cif_int, requestId_int: ri!requestId_int ), a!columnsLayout( columns: { a!colum

I'm using view to get different columns from two tables and using that view to generate the report in excel.  So my question is : After the 5-6 years the data will be large inside the view which I'm using currently, so is there any alternate way to get the data faster as compared to view in Appian. Thank you.

Error : Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PLZG0] : An error occurred while executing a save: Expression evaluation error: Cannot update List of Dep_Record; length of assign value list (0) does not match length of the list to update (1). Desc: Have attached a file and when trying to detach the same file I am facing the above error.Please check and suggest. Code : a!localVariables( local!minimumRecord:1, local!bulkUpload: a!refreshVariable( value: a!forEach( items: enumerate(local!minimumRecord), expression: 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD'( 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{c4a92bde-e02b-4695-a292-2ff46a89c88e}createdBy': loggedInUser(), 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{de5c9d80-f57b-4035-a8f0-98af6439584e}createdDate': today() ) ) ), { a!forEach( items: loc

i have added a link in a selectable grid, when we select that row then the link should be enabled how to configure that

Hi I need to find out if a particular date which is stored in record type is from the previous month.  For example today in September I'm finding that 7th of August 2023 date (Already present in record type) is from August month.  How can I achieve this?  Please give me the suggestions. Thanks.