AI and Agentic Automation

I want to Create time slots for specific interval and get a List of all slots (like 20 min or 30 min slot) for Interval.

I have the following which i saved as a process variable of type text { "userId": "abc123", "submissionId": "111222333", "createdDt": "2022-06-17T04:07:19.611Z"} I want to remove spacing between the commas and colons, trying to do so with substitute(pv!text, ": ", ":") and substitute(pv!text, ", ", ","). It works for the colon, but not for the comma, so the result is the following { "userId":"abc123", "submissionId":"111222333", "createdDt":"2022-06-17T04:07:19.611Z"} Also, when i use stripwith(pv!text,","), the comma can be affected and removed. Wondering why substitute cant do the same. Any ideas as to why this is happening or how else I can remove the space between the comma?

I have a requirement where the client would like to be able to scan barcodes using a handheld scanning machine and have them save in the Appian UI. I have read the following documentation: https://docs.appian.com/suite/help/20.4/Retrieve_Data_By_Scanning_A_Barcode.html From the documentation, it seems that it is only possible to scan a barcode and show it on the Appian UI using a mobile device (smartphone). Is there any way to achieve the same functionality using a handheld scanner, either Bluetooth or USB?  The brand the client has is Symbol.  For example: www.amazon.com/.../B00HYOPAJG

instead of having text for a rule input which accept user names, is it possible to have a user type? 

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