General

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? 

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

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?

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 ?

.

All of the sudden a client appears be getting this error when trying to start processes.  "The Process Model cannot be started. There is no published version". This happened in a test environment. upon inspection of the process model it seems like the PM was missing the latest versions as if someone came in and deleted them and now there were only a few old unpublished versions. A quick solution was to save and published the PMs in the dev environment and deploying them again. However, I don't know what might have caused this problem? Has anyone run into this problem and found the cause for it? Some pointers would be helpful to ensure that this doesn't happen again. Is there a log registry I can look that would information about this issue?

Hi All, Could someone please help on Stored Procedure used in Appian? My main question is why do we need Stored Procedure in Appian? What is the main purpose behind using this? In What scenario it can be preferred over views? Thanks Faisal

Hello, I would like to know whether Cucumber/Fitnesse testing only refers to "on premise Appian Installations" or are they usable as well for "Appian cloud installations". Do we need an specific set-up (eclipse IDE, local servers, etc...) to set up the environments?. Sorry but it's not clear to me reading Cucumber and Fitnesse sections on the playbook. Thank you!

Is there a way to add client's custom disclaimer text as a footer which will be visible on every site page?

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 the page.

Hi Team, I was not aware about the archive task thing, I lost many tasks . I need those task back or see them. Any way to do that?

local!a:toInteger(20),document(local!a,"id") works, but when Replcaed local!a with ri!Table_Name.docId getting error, How to fix? a!linkField( label: "Link", labelPosition: "ABOVE", links: { a!documentDownloadLink( label: "Document Link", document:document(6802,"id") -->replced 6802 with ri!Table_Name.docId gets an error ) } )

Hi All,        I am getting the below mentioned error in Grid field when i try to submit the form. Expression evaluation error [evaluation ID = N63DMP1Y] in rule 'A' (called by rules 'B' > 'C') at function a!gridField [line 62]: key. Request to provide reason for this error occurrence. Thanks in Advance Pradeep.B

Hello, I have the following list of strings coming from a query:  List of Text String - 4 items"user1"(Text)"user2"(Text)"user2; user3"(Text)"user4"(Text) How  I can sort that so the final result will be list of strings of only unique values:  Result:"user1"(Text)"user2"(Text)"user3"(Text)"user4"(Text)

Hi All, Is there a way to edit / update / modify the text inside the word doc template in Appian by the end user apart from the parameters passed. Any help is appreciated. Thanks, Pramod.

Hello community, Is it possible to add values from a list of string of string to fields where string 1 of the list maps to field 1 of the CDT, sting 2 to field 2 of the CDT etc.When I pass the list of strings to the CDT as a parameter in the expression it passes al the strings to field 1.I want to make the expression dynamic, so for example looping through the list of strings and add them to CDT field 1, next CDT field 2 etc.I do not know how to set the values of the CDT fields based on their index. All the fields in the CDT are of type text.To illustrate for example CDT Alphabet with fields Letter1: "", Letter2: "", Letter3:"".List of String{("A"),("B"),("C") etc.Now I want for the length of the string, adding A B C to Letter1, Letter2, Letter3 using a Loop. (is it possible to use index of CDT field instead of fieldname?)My second question is, is it possible to just add the whole list as a parameter when I cast it to a certai

Hi everyone,I apologize if this question has been asked before, I just got started with Appian and have been tasked with implementing the web API with our PHP website. I looked at the documentation but English isn't my first language and I find it hard to follow. Are there practical examples of web api with PHP I could see? It would be really helpful.Thank youBlumenversandMihail SchweizerZürich

Hi, i have written a query filter which is working fine and displayed that in interface. Now i need to download Excel which is also working fine but i need not have to include option: best Suppose i have a drop down field which contains values: Good, better, best. But when i download Excel i should not see best option in Excel(instead it should be blank ) ..but the value in complete row should be downloaded.  applyWhen: {rule!AAP_isNotEmpty(ri!Status),remove(ri!Status,wherecontains("best",touniformstring(ri!Status)))} Can someone help with what change i should do in code