Foundation

Hi, I have created a view and then displayed the value in Read only grid. Every thing is working fine. But there is no ID field which will display 1,2,3,4...based on number of Rows. Is it possible to add it from Appian Side(because there is no ID field in Database)..

Hi All, I need to find the common values from one List of Text String to another list of string . I have tried to use foreach but still there is no luck  !

Can someone help: CASE                                WHEN ISNULL(pr.[isDefunct], 0) = 1 THEN 0                                WHEN ISNULL(pr.[isCancelled], 0) = 1 THEN 0                                WHEN ISNULL(ab.IsEscorted, 0) = 0 THEN 0                                WHEN bc.Movement <> 'CR Movement' THEN 0         &n

Good day, Im new to appian and Im currently doing the Appian Developer Skills Practice Application. In the part where Im suppose to create an Interface that has a column chart, the guide says to select a data source in the component configuration pane. But as seen in the screenshot below there isnt one. Can anyone help me or point me to where I can find this option. Thanks [emoticon:6d505171faa4497c85c5ca27290c555d] P.S. This is the data source option that I cannot find

Hi All,      i have written an interface code , which calls an query entity multiple time , because of which sometimes am facing Query timeout issue, Please help me in Optimizing the code with( a!localVariables( local!dcSelectedrole : ri!dcSelectedRole, /*super admin variables starts*/ local!superadminPOCdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "POC", typeValue: "1" ).data ), local!superadminNonPOCdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "POC", typeValue: "2", pagingInfo: ri!paginginfo ).data), local!superadminGenderFdata: if (rule!APN_isBlank(ri!programId), {}, rule!CMP_getChartDataprogramLevel( roleType: "SuperAdmin", programId: ri!programId, type: "GENDER", typeValue: "1", pagingInfo: ri!pag

the provided ur is not working how to hit the url to display the content in DB

Hi All, I have state and county drop downs when changed states loading respective county in 2nd dropdown i.e.county dropdown. When i selected county value and tried change state value, getting error as - intterface Definition: Expression evaluation error at function a!dropdownField [line 76]: A dropdown component [label=“County”] has an invalid value for “value”. All selected values must be present in the choiceValues array, but value was Beaver and choiceValues was Carson City; Churchill; Clark; Douglas; Elko; etc... saveInto:  {ri!PTS.state,a!save(ri!target:PTS.County,value:null)} Thanks, Deepak

Hi team, My use case requires me to select multiple options like: north, south, east ,west which am able to configure and it's working perfectly. But there should also be an option to select all(I.e North, south, east, west) and based on it data should be displayed. Can someone help with the code.

Hi. I am looking for a way where I can filter down the objects in designer using the created by attribute or filter them between a date range of creation and NOT modification.Similar filters are available for modified by and modified on date range but is there any way to filter the objects by created by, or creation date? Thank you in advance.

Hello everyone I have a question. I have an interface in a process. Inside the interface, I have local variables with values ( f.e. local!test) but I will save draft the instance to continue later. When I am back to this,my local!test is empty , anyones knows how could i fix that? Thank you for all.