AI and Agentic Automation

hello! i have a question, well, i have a dropdown with some data, for example, in a dropdown i have states, what i want is that when i select a specific state, a list of cities appears in another dropdown, with my team we have done it with if, if nested, match, but we keep getting errors, regarding the interface, and with the definition, it even tells us that the values of the cities in the other dropdown are invalid, for your attention, thanks alot!   

I need to get a list of all objects separately of a application , the application contains around 3500 objects , any suggestion how can i get this 

Hi All, Assume like the user have entered the below start date and end date and also, they have selected some contracts and price groups based on the date logic. Start Date: 15th June 2022 End Date: 15th July 2022 Now I have a table like below with all the selected data, Contract number Price grp id Frequency xxx xxx-1 Monthly xxx xxx-2 Quarterly xxx xxx-3 Semi-Annually xxx xxx-4 Annually   My scenario is like I have to check the frequency from above table(cdt) and split it into multiple rows based on the date range (Start Date & End Date) and update in another table(cdt),please refer the resulting expectation, Case 1: Frequency: Monthly>>then 2 rows >>1st row: {Start Date: 1st Jun 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul 2022 – 31st Jul 2022} Case 2: Frequency: Quarterly>>then 2 rows >>1st row: {Start Date: 1st Apr 2022 – 30th Jun 2022}>>2nd row: {Start Date: 1st Jul

Hi, I'm doing the activity of the course, but I got a problem with this query:  a!queryRecordType( recordType: 'recordType!{058be2d0-0acb-453f-93ac-4c9f650cf004}Vehicle', fields: a!aggregationFields( groupings: a!grouping( field: Vehicle.make, alias: "Vehiclemake" ), measures: a!measure( field: Vehicle.make , function: "COUNT", alias: "count" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 )) .data when I tried to test the rule I got this error: Expression evaluation error at function a!aggregationFields [line 3]: Could not find variable 'Vehicle' I followed every single step in the exercise So, I don't understand what's the wrong here. Can anyone tell me what's the wrong??

Has anyone faced issue with char(0015)? I was trying fetching pdf text from file by splitting with char(0015). However, everything contains 15 in a document file is removed or replaced with blank value. Here is the code I tried for the same. a!localVariables(  local!text: getpdftext(document: 32030),  local!test: a!map(id: "header", value: local!text),  local!text1: split(    /*local!test, char(0015)*/    substitute(local!test, char(13), ""), char(10)  ), )

Hello, Can anyone tell me how can I access the expression rule? I want to create new expression rule. 

I read about IDP how advance and easy to use Appian's IDP for document processing. I am wondering a scenario where Appian's IDP is not an ideal solution to use? Does it have any limitations?

Hi  i have to display highlighted text in bold    code to display the text when i try like this   and the output is coming like this what is the mistake?

I am querying data to get address but when the value is null I am getting ",,,,,". How to remove this comma if fields are not theretrim(concat( property(local!address,"fullName",null), property(local!address,"buildingNumber",null) & ", " & property(local!address,"streetName",null) & ", " & property(local!address,"district",null) &", "& property(local!address,"unitCode",null) &", " & property(local!address,"cityName",null) & ", " & property(local!address,"zipCode",null) ) )

 Expression Rule: cast('type!{urn:com:appian:types:HSM}HSM_Elements?list', a!queryEntity( entity: cons!HSM_Entity, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 5000, sort: a!sortInfo( field:"S_No", ascending: true, ) ) ) ).data ) I want to retrieve every data without Status field from database. Is it possible to retrieve using rules?

Hi  how can i write above query in ER?  can anyone help me with this? i have tried but it gives error

Hi, In some ER code, I have found this kind of things : rule!APP_GreaterTo(value: _, to: 14), or :       contains(        reject(          isnull(_),          ri!names        ),        tostring(ri!name)      ),                                                  Could you explain me what does mean that "_" ? is it just to specify we do not want to pass any parameter in the function ?  (because "isnull()" is not authorized) but why "value: _"  in place of "value: null" ?

Hi All I have a requirement to query a value in nested CDT which is in 1:M relationship Is it possible ?

a!gridColumn( label: "Assignees", sortField: "c4", value:group(fv!row.c4, "groupName") ), Using this code in a gridfield. Getting the data from queryprocessanalytics to populate a grid. Field c4 contains the group number. i am trying to get the corresponding group name. Pls help.

I have a REST service that returns JSON which is converted to Dictionary by the integration.  I have CDTs I have imported from the service WSDL (so the property names exactly match the JSON names).  The problem is that array properties are left null instead of being populated. I'm trying to convert it this way.... with a single call to cast of the top-level node. /*local!rawData: rule!SH_GetLibraryIntegration(libraryName: ri!libraryName) */ local!rawData: a!fromJson( "{""GetLibraryResult"":{""Name"":""Uptown Public Library"",""HeadLibrarian"":""Kathlyn Walton"",""Books"":[{""Author"":""Fyodor Dostoevsky"",""Title"":""Crime and Punishment"",""IsCheckedOut"":false,""DueDate"":null},{""Author"":""Charles Dickens"",""Title"":""A Tale of Two Cities"",""IsCheckedOut"":true,""DueDate"":""01-10-2021""}]}}" ), fn!cast( 'type!{http://schemas.datacontract.org/2004/07/TestService}Library', local!rawData.GetLibraryResult ) However, The "books" (in my

Hi All, I am getting error in below expression  a!localVariables(           local!userName: "xyzUser",           if(                isusernametaken(local!userName),                a!isUserMemberOfGroup(local!userName, cons!PP_GROUP_CONSTANT),                0              )) Error as Expression evaluation error at function a!isUserMemberOfGroup [line 5]: [InvalidUserException] I observed this issue with deactivated user in only one environment where in lower environment its working fine with deactivate users as well. Thanks in Advance!

Hi all, I'm currently having an issue where a!exportDataStoreEntityToExcel is only working for people in the admin group for the application. Is there a way to configure a!exportDataStoreEntityToExcel to work for "All Users" within the application?

How can I write below SQL query through query entity in Appian Select * from A where A.colmn1 = max(A.colmn1)

HI  here i have used <br> tag for new line now the issue is whether the values is present in limitamout or not it's going to new line/ breaking the line  this is how the output looks like  but whenever the data is empty then it shouldn't break the line  how it can be done 

hi All ,  How to update a document type constant.  I am trying to update using a Update Constant smart service , but its not worth it .Please tell me so that I can achieve this easily.  Thanks in Advance 

Hi Community, I need to display the list of folders and files inside specific SharePoint folder. I have the access to see the folders and files in SharePoint, but the Appian Integration shows no result although the integration tests successfully. Note that, the connected system test connection success too. This is the folder path: This is the integration result:

What is the best approach to trigger workflow when ever an image is uploaded.? Can the image upload be done using an web API exposed by Appian? Can anyone kindly share any documentation or example for implementation help

What is the best approach to trigger workflow when ever an image is uploaded, Can the image upload be done using an web API exposed by Appian. 

I have doubt on POST API, Firstly I am creating an API  can I know where the document would come within Appian from external system using POST API.