General

How to Filter data from Rule input with is of type cdt ?  for example ri!Questions is of type cdt where i want the only data with active =1 , ri! questions contiains active 0 and 1 data both.

Hi All, What is the difference between Appian Designer / Appian Level 1 Credential and Appian Certified Associate Developer. Are there differences between topics in the exams?  Are the first two still valid having done the refresher courses?  Thanks, Eleonora

Hi, I am trying to update an array of CDTs recursively. Base Array :  { {name:"Alex",rollNumber:null}, {name:"Stephen",rollNumber:3}, {name:"Dave",rollNumber:4}, {name:"Steave",rollNumber:5}, {name:"Rosey",rollNumber:7}, {name:"John",rollNumber:8}, {name:"Nile",rollNumber:10} } Now, If I insert number 4  where rollNumber is null , if that number exists in CDT array then all numbers greater than 4 should increase by1 until all duplicates are change to unique number, but all numbers less than 4 should remain unchanged. This is how numbers should change : 4->5, 5->6 Since there are no duplicates after 6 then increment should stop here, Updated Array: { {name:"Stephen",rollNumber:3}, {name:"Alex",rollNumber:4}, {name:"Dave",rollNumber:5}, {name:"Steave",rollNumber:6}, {name:"Rosey",rollNumber:7}, {name:"John",rollNumber:8}, {n

nterface Definition: Expression evaluation error at function a!dropdownField_20r2 [line 323]: A dropdown component [label="New Case Owner"] has an invalid value for "choiceValues". Choice values cannot be null.

Hello Appian, I am greatful of Appian for all the support and what you are doing now.There's just a little thing to ask for. 1. It would be great if you could add just one more label line in the grid, so it could allow us to use the sub header. 2. In USER Properties, it would be nice to be able to change the column name of Custom Fields to the name we want instead of Custom Field 1, 2, 3. 3. In the grid, when the header is in English, the width fits well. But in Korean, it is compressed like the picture below. Thank you.Always wish the best for you.

Hi all, We need to delete files from the Appian local file system on linux (Appian 20.2). We are running on premise. Is it possible? Kind regards, Jesus

We would like to enable users to logout form an application screen by pressing a custom button. possible ? 

Hello I need help with the format of final result: { a!localVariables( local!data: a!queryRecordType( recordType: 'recordType!{4e239f9b-3c32-4a2d-9080-0a76750fe5eb}BWP Clients', fields: {'recordType!{4e239f9b-3c32-4a2d-9080-0a76750fe5eb}BWP Clients.fields.{f759f435-fee5-4c98-8bd8-dc9c00f703a5}companyName'}, pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100) ).data., local!resut: a!forEach( items: local!data, expression: fv!item ), local!resut ) } The result of this execution is:  List of BWP Clients - 45 items BWP Clients id1(Number (Integer)) companyName"Company 1"(Text) BWP Clients id2(Number (Integer)) companyName"Space"(Text) What I need as result of this is just a simple list with company Names comanyName: "Company1" companyName "Space" any help will be appreciated. 

want to display dynamic field name on screen but with updating initial as capital and adding one space in between.Field name always start with small caps eg. "indiaChinaFrance" to "India China France" eg. abcDefXyz to "Abc Def Xyz"

Hi, Is there a way to initiate post deployment automated rule testing for just the items in a patch and not a whole application?

Hi, If I need to get the vehicles Data where ID in {1,2,3}, I can do this : index( ri!vehicles, wherecontains( {1, 2, 3}, ri!vehicles.id ) ) But is there any way to do the same thing with a negation (a kind of notWhereContains) ? I mean I need to get the vehicles data where ID not in {1, 2, 3}. Of course, I can then use a foreach to get the correct data, or create an exclusion list items, to apply the whereContains on the latter, but is there any other way to do it with a single simple instruction ?

Hi team, i have read only interface which will update based on related action but it is not getting refresh until i use summary button but my requirement to refresh upon upates. In my read only interface i dont have any local variables and not even grid, So will you guys please suggest me any other way to refresh my read only interface upon updates. { a!columnsLayout( columns: a!columnLayout( a!richTextDisplayField( value: a!richTextItem( text:"Go back", style:"EMPHASIS", color: "NEGATIVE", size: "MEDIUM", linkStyle: "STANDALONE", link: a!startProcessLink( processModel: cons!PO_dummyProcessModel ) ) ) ), ), a!richTextDisplayField( value: { a!richTextItem( text: "Status" & ":", size:"LARGE", color:"#292421", s

We have a use case (on Appian), where a user wants to see both the older as well as new updates made to any field of a Record, and to pull out an excel version of the same from Appian. For example, a record with Car's mileage initially marked as 10000, and then updated to 12000, the user wants to pull an excel that shows two rows of thus record with both the mileage values, also with a timestamp (Created or updated date)

Hi all, We are currently running into an issue with selecting record action items with the Cucumber for Appian framework.  We've tried every possible predefined Appian step and fixture.click related to actions and buttons, using both the action name, key and index; however, it does not seem to detect the component.  I attached the snippet of code of how the recordActionField is configured: a!recordActionField( accessibilityText: "Actions", actions: { a!recordActionItem( action: 'recordType!{cf46c7e0-d175-4d07-9daa-2d3a1739795e}ECMS Patrol.actions.{6c6e1f29-2673-4099-a78d-305b32688e93}createPatrol' ), a!recordActionItem( action: 'recordType!{46271c62-4660-4e17-a39a-a5ea6a9eca68}ECMS Incident.actions.{e51cba01-d80a-4893-a583-21c711ff357b}createIncident' ) }, style: "CALL_TO_ACTION", openActionsIn: "DIALOG", align: "END", showWhen: a!defaultValue(value: ri!showActions, default: false) )

I have a requirement where i need to filter values according to date but the field in CDT is given as date and time field.  For Eg: bookingDate in CDT is the date and time field.  But, when I filter the data in the expression rule ,  I need to get data based on booking date only not time. ( For eg: I need to get the number of people who booked the tickets for the day but i dont want  according to date and time I just want the count for the particular entire day). Can anyone please help me to solve this! Thank you in advance.

We have a requirement to build the scheduler process to run 3 days before every quarter. The  Logic has been built in the expression rule . When I am trying to call the rule in the timer to get the specific day to run, the process is not running whereas when I implicitly paste the logic, it works. Is there any limitations that expression rule can't be evaluated inside the timer.

Hello, We have a problem when uploading a document with a webApi, to do the test we are using postman, we pass the document to it, we pass it the name and the extension as follows: We see that it goes up to the folder that we have indicated in appian, but when we try to download it to open it, it tells us the following: I have tried with jpg and the same thing happens to me: code: a!localVariables( /*Check whether the request body contains a document*/ local!success: not(isnull(http!request.body)), if( local!success, /*If a document was uploaded, return a successful response*/ a!httpResponse( statusCode: 200, headers: {}, /*Print the document id, name, and extension of the uploaded document*/ body: concat( "Upload Successful: ", document(http!request.body, "id"), " - ", document(http!request.body, "name"), ".", document(http!request.body, "extension") ) ), /*If no document was uploaded, return an error code*/ a!htt

After i click on a particular record in a list , i get this record summary page . So, i inserted back button to go back to the list . But when i click on the button , it goes back to the list but it contains the record summary header ( like seen below , with the record title and related action). Can anyone suggest how to solve this ! I tired using the safe link as well , but it didnt work.

Hello, I am using the appian selenium api library for my tests and my problem is: How can I locate a textbox that does not have a name? I am currently using: fixture.populateFieldWithValue("", "");  but I don't know how to use if the element doesn't have name. ¿There are a way to use xpath us selenium? ¿There are another option that i can use?

Is Apian Mobile app iOS 15 Compliant  ?

We are using MySQL DB, we have a use case where a text column in the DB table is having a UNIQUE constraint that accepts NULL, all values apart from NULLs have to be unique.While using write to DSE smart service, Appian product by default is converting the NULL value to empty value/empty string and mapping to table, due to which we are facing issues due to unique constraint while inserts.Please suggest a solution to overcome this issue.

if( fv!success, if( /*In the response, if the resultCode parameter is "Error," or the errors parameter is not null, return false*/ or( fv!result.body.messages.resultCode = "Error", not( isnull( fv!result.body ) ) ), false, true ), false) The API response I am getting  HttpResponse statusLine: "HTTP/1.1 200 OK" statusCode: 200 headers: Dictionary Cache-Control: "no-store" Pragma: "no-cache" Content-Type: "application/json; charset=utf-8" X-OPNET-Transaction-Trace: "9d4ed313-4f4e-4699-9a26-8192fc4fabcb-3288-74350853" Access-Control-Allow-Credentials: "true" Access-Control-Allow-Headers: "x-requested-with,cache-control,content-type,origin,method,SOAPAction" Access-Control-Allow-Methods: "PUT,OPTIONS,POST,GET" Access-Control-Allow-Origin: "*" Strict-Transport-Security: "max-age=31536000" X-Cnection: "close" Date: "Tue, 26 Oct 2021 08:59:16 GMT"

Hello, In a project we have to do an appian update from version 19.2 to 21.3 and therefore we are reviewing the pugins.Until now we had a service exposed in appian in which the service that called us passed us a string in base64 in a json and we converted it to a document with the smart service base64todoc, it seems that this plugin is deprecated for the new version.Does anyone have any idea how to supplement this functionality? I was looking and I saw the integration object but in this case it would not help us because they consume us and they already pass this chain to us at the entrance. Greetings and thank you

I have one CDT where a single field which stores date and time. Now i am selecting a date from datefield component. I have a grid in the same interface where i am selection date from datefield. Once i select a date from this datefield, then the grid should filter all the dates from the grid .How can i do that?

For a short period of time, perhaps since we upgraded to 21.3, I've noticed a strange behavior with Dropdowns. When I pass a null value, I get a pink box that says I need to provide a placeholder text.  This is expected.  However, now, when I DO provide the placeholder text, it still complains in a completely different error that simply states that it has received a null value.  But dropdowns with placeholder text are SUPPOSED to accept null values.  I haven't found a way around the issue except to trick it into working by making sure the value is never null, and providing a value to replace null if it is. Basically, placeholder text now seems to be useless.  Is this an Appian bug?  Does it work differently now?  Are placeholders redundant?  Is it the 21.3?