Foundation

Hi, I have a CDT based on a view I built on the Appian MariaDB database.An expression rule (say, rule!GetAllData) pulls from the corresponding DSE through a simple queryEntity, retrieving all results.In an interface, I have a local variable defined as the rule result:local!data: rule!GetAllData()I also have a refresh button, with a dynamic link supposed to refresh the content of the variable, viaa!save(local!data, rule!GetAllData()) The weirdest problem happens: when clicking the link, nothing changes. Appian seems to somehow cache the results of the rule. Note that the records in the query differ between refreshes, so Appian maintains cached records that do not exist in the view anymore!I have verified this from the interface designer, inspecting the value of local!data.Even this does not solve the problem:{  a!save(local!data, null),  a!save(local!data, rule!GetAllData())}Even if I comment out the second line, click the link, verify that local!data is set to null, decomment

I am attempting to config the node and it works great when I use the subject, but the subject will change except for "RE:" in front of it.  When I attempt to set it up with ToEmails or To Names it never kicks off. Thoughts?

Hi, I am calling a startprocess smartservcie on submit button click in my interface. and i have set the submit as true for that button. So here before getting the response from smart service, interface is moving to next node in the process model. I want to get the response and based on response need to validate the interface. If no issues, then need to move to next node in the process model. Process model is starting asynchronously so i think whatever i am performing in onSuccess of srtartProcess, is not happening before submitting the interface. Any suggestions on this please.

I need to create a Unique ID in View which is not available in Table. I searched many places but all told to use row_number. Even though i tried but its throwing an error: Have used this  SELECT Row_number() OVER(ORDER BY `locationName`) AS `RID`, Note: `locationName` is available as column and have used in the view that have created   Can someone help out with workable code

Hi, I found in an existant ER code this kind of multiple condition: if(cons!TEST = "1", "VALUE 1", cons!TEST = "2", "VALUE 2", cons!TEST = "3", "VALUE 3", cons!TEST = "4", "VALUE 4", cons!TEST = "5", "VALUE 5", "" ) That seems to works fine, but when I put this condition in an interface and click on "DESIGN MODE", I obtain this error:    "Cannot load Design Mode : The function ’’if’’ [line 275] has 3 parameter(s), but instead passed 11 parameter(s)." Where is the truth ? 

In DB i have table  with columns firstnam,emailid and lastname data, I want to show in Dropdown firstanam,lastname and after selecting dropdown value want to query same table to get emailid  Step 1: get firstname and lastname to concate and store in array for dropdown purpose local!fn:{index(rule!PTS_QueryUsers(local!selectedDept),"firstName",{})}, local!ls:{index(rule!PTS_QueryUsers(local!selectedDept),"lastName",{})}, local!user:if(isnull(local!selectedDept),{},union(apply(fn!concatenate, merge(local!fn, local!ls)),apply(fn!concatenate, merge(local!fn, local!ls)))), Step 2: Show firstname and lastname to concate and store in array for dropdown purpose a!dropdownField( label: "Assigned Name", labelPosition: "ADJACENT", placeHolder: "Select User", choiceLabels: a!forEach( items: local!user, --> FirstNam,LastName expression: fv!item ), choiceValues: a!forEach( items: local!user, --> FirstNam,LastName expressio

Hi Team, I am getting list of user or groups from a ER like below Now I want to convert this User object to username/name or email. Or easy language I want to fetch user details from this object  Please help me I tried user() but it gives parameter error maybe user() accepts username not user Please Help

Hello, I have a requirement where i need to show a pop up warning message when user accidentally clicks on Summary tab when actually they are in Related Actions tab performing some operation (e.g. updating).

When I click on "add request url value" It takes me to a random row that it in that data already. But I want it to take me to a new and clear row.  addRowlink: a!dynamicLink( label: "Add Request URL Value", value: { CRETD_BY_USER_ID: loggedInUser(), CRETD_TMST: now(), },

How do you check if variable is a list? Assuming that the variable is a local variable

For my service integration, i have to send the request in json format. I am converting my nested CDT into json format by using a!tojson function. Here the issue is my service has some optional input parameters and when i am passing null for those parameters, a!tojson is converting them to "" (double quotes). My service is not accepting the "", i should pass Null. a!toJson(  'type!{urn:com:appian:types}_testCDT'(    name: "ram",    age: Null,    place: ""  )) json looks like : { "sampleName"  : "Test", "Organization" : { "Name" : "TestName", "Branch" : "" } } here Branch value should be Null instead of "". Thanks in advance.

Which version for BPMN Appian use? 

Hi all, Does anyone know how or have examples of creating a line chart with the time on the x-axis and the date on the y-axis? Looking to see the number of requests that come into the queue for an application based on time of day and date. Thank you.

Im trying to write a expression rule where there are two ri variables , one ri variable has type list of users and other ri variable is of type list of numbers. something like below ri!users: {"abc","def"} ri!numbers: {1,2,3,4,5,6,7} i have a use case where i should need to receive list of dictionary in below format { user:"abc", number:1 }, { user:"def", number:2 }, { user:"abc", number:3 }, { user:"def", number:4 }, { user:"abc", number:5 }, { user:"def", number:6 } . . . etc

Hello community, I have the following scenario, I have a array of student details. It has fields like student id, subject id, question paper id. I want to group by subject id and update the question paper id in the array. Given Array 1: {student id: 100, subject id: "S1", question paper id:   }, {student id: 200, subject id: "S2", question paper id:   }, {student id: 300, subject id: "S1", question paper id:   }, {student id: 400, subject id: "S2", question paper id:   } {student id: 300, subject id: "S1", question paper id:   }, {student id: 300, subject id: "S3", question paper id:   }, Array 2: {Q1,Q2,Q3} Array 3 : { S1,S2,S3} Expected Output: {student id: 100, subject id: "S1", question paper id: "Q1"}, {student id: 200, subject id: "S2", question paper id: "Q2"}, {student id: 300, subject id: "S1", question

Hi, Initially when clicked on submit button where validate is true, this will validate and show messages like "Enter a value" for each field. Now when i again click on the another Cancel button where validate is false, then the validation is still showing  " Enter a value" should be disappeared. which is not happening now.

Hi, I am getting date and time in date field from data base. I am able to convert it to time using datetime().  I am using a!exportDataStoreEntityToCsv() to download the csv file but the issue is am not getting expected output. but when i place the cursor on that cell in csv file then am able to see the correct time.  My requirement is that time should be displayed correctly without putting the cursor on that cell. Can someone help. Thanks. 

Hi Everyone,  I need help on the below issue :  We have a dependency between two screens, so  in the first screen we enter an XYZ fields and save it and depending on the Role what we select in the second screen we get the XYZ fields of first screen what we entered and then save it. The problem here is , after saving it, when we navigate to the first screen, XYZ fields values are not displaying. It will display after refreshing it or if we wait for few secs. Kindly let me know is there any way we can display without refreshing  or reloading the page.

Hi all, Has anyone created a line chart having the Time on Y-Axis and Date on X-Axis? We're looking to visualise data for  the time of day that requests enter the queue for an application to identify peak periods. Below is a sample interface we're playing with, essentially we want to change the "# cases" on the Y-axis to "time of day". Any information or examples will be much appreciated! Thank you. a!localVariables( local!requests: a!dataSubset( data: { { created_on: datetime( 2019, 1, 10, 5, 7, 10, 0 ), id_count: 65, time: time( 5, 7, 10, 0 ) }, { created_on: datetime( 2019, 1, 11, 5, 7, 10, 0 ), id_count: 66, time: time( 5, 7, 10, 0

Let's say I have the following query where the data is being filter based on siteIds local!estimations: rule!EEP_QE_getEstimations( statusId: cons!EEP_VAL_STATUS_ACTIVE, columns: {"site_id_fk", "status_id_fk", "estimation_business_id", "id_pk"}, siteIds: local!selectedSite ).data Now, I'm saving local!selectedSite using a dropdown menu a!dropdownField( label: "Site", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!sites.name, choiceValues: local!sites.site_id, value: local!selectedSite, saveInto: local!selectedSite, searchDisplay: "AUTO" ) the value of local!selectedSite is null at the start so everything is queried, as expected. If I select a value from the dropdown the data is filtered accordingly. But when I select a value and then I select the placeholder, the query does not return any values.

I have a need to add a confirmation link for the email recipient to be able to click to confirm information in the email. Has anyone done something like this?

Hi, I have a process that displays a form. The latter contains an upload component and a donwload link. The upload mecanism works fine as I can see the "document_id" saved in my rule Input. Could you tell me why when the user is in modification mode of the form (not readonly) the click on the download link throws this error please?     {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An error has occured"} If I save the form, leaving the process terminating, writing the data in DB, and then re-open the form (from the same process), the download button works fine. When I am in modification of the form in the Designer, when testing the link, I can see the error is systematic, but if I launch a testing Expression rule to examine the document ID, I can verify that the document in file system Appian is fine :     todocument(51755) => gives me the co

how to edit groups in group picker which are stored in database as groupids with a related action from a form

There are two datatypes in Appian: dateTime and date. How can we take only time as input?

Hello,  I would like how to formulate string which can be foreached after with only working dates between two dates.  Lets say if I have  start date: 2021-02-15 19:11:43 end date: 2021-02-22 19:11:43 In this case the result have to be {2021-02-15, 2021-02-16, 2021-02-17, 2021-02-18, 2021-02-19, 2021-02-22} Any ideas how this can be achieved ?