AI and Agentic Automation

can anyone suggest a usecase  for insertquestions() and extractanswers() 

Hi Everyone, I have a query which will receive a text input based on that it will query data.(The data is like the reviews received for books under one particular genre, say I give my input as romance that will give all those reviews under all books in that genre), But I want to group it based on the book name. So I can get average ratings for a particular book.On grouping , I am getting only names of the book and not the other details. I have  attached the required snap of code for it. In the First pic there is 9 items as output but when I group it the output will be 5 items. I want only the details of 5 items without repetition as in the second pic and I also want to know how to calculate average rating for these books.Please help me out guys!!

Hi All, I have a requirment in my Interface that I am displaying the data in a grid through Expression rule . But in that there are some fields like say isA , isB and isC  with 0 and 1 value in database . But now the The condition is that I have to show the Yes , No , N/A in the grid instead of 0 and 1 on some conditions like 1. If isA is 0 in database  then isB and isC should be N/A in the grid and isA will No in the grid 2. If isA is 1 and isB is 0 in the database then isA will be yes , isB will No  and isC is N/A in the Grid 3. If isA is 1 and isB is 1 in the database then isA will be yes , isB will be Yes and isC yes/No based on value in database Thanks in advance

Hi  All ,  How to create a expression Rule where I want to check single or multiple mobile number is present or not  in a DB . Ex   1234,4567 present in a data base . If these two are there then return true else false  

in a only view table in a grid colum the field is an integer but for requirements i sent that value to an a expresion rule and result in a value but i want to sort that field also with the integer that result from the expresion rule there is a way to sort that?

Hi All, I am having a list of months shuffled in a list. I want to arrange them in their chronological order. But I can sort only on alphabetical order. Help me guys. local!months:{"June","January","March","Novemeber","February","October","December","April","July","May","September","August"}, sort(local!months). Thank you

Hi , Can i use IDP with Aamzon AI instead of Google AI? Can i use Google AI with AWA S3 bucket for storing the files? Any case studies of IDP using Portuguese docs? Thanks Krishna

My requirement is to remove the duplicate values from a rule input of type text. Here is a sample input and output. Input: Hello hello Hello there there past pastures Output: Hello there past pastures

Hi All, I am getting the output as list of numbers, but I want the respective output in array format ,since I have to use that output in "value" parameter  in query filter in another expression rule. PFB the screenshots, Can you please help me on this to convert list of numbers to array, like {56,57,58,....} Thanks in Advance.

Hi all, this is a problem that's been troubling me for some time. Let's say that I have the following date, "08/18/2021". I know that it falls on a wednesday, and I want to substract enough days in order to get "08/16/2021" as the result. Same for any other date in the same week, I'd like to automatically detect how many days have passed in the week so it always results in the Monday of that week. My approach has been the following: a!localVariables( local!ctrlday: weekday(todate("08/18/2021")), datetext(todate("08/18/2021") - day() * (local!ctrlday - 3), "yyyy/MM/dd"),) And it "works" for that example, but if I were to calculate "08/17/2021" and substract 2, it would end up with "08/15/2021". Any ideas on how to make this behave properly? Thank you in advance.

Rule name is available (retrieved from DB ) in as pv!integration.mappingRule.I am trying to run this rule in Node output expression rule I have tried various options like rule!pv!integration.mappingRule or rule!eval(pv!integration.mappingRule) or eval(rule!pv!integration.mappingRule ) None of them works .  Any idea , how to make this work? Thanks in advance.

Hi, I have a below output from my expression My requirement is if "expr" of every Dictionary contains "rowcode" that row code needs to be replaced by "expr" of that particular rowcode (for eg: "(FRML_88_1+FRML_88_2)" this expression contains rowcode so i need to replace it with expr "((123/12)+(1284*64))" and  the final output be like  "(((123/12)+(1284*64))*(9090+122))"

Hello,  I am using executestoredprocedure() function to get the data, but when i am executing the expression rule it is not returning any data. a!localVariables( local!result: executestoredprocedure( dataSourceName: cons!dataSource, procedureName: cons!storedProc, inputs:{ name:"user_id", value:"ankita12" } ), local!result)

Dear Experts, There is a requirement that, a given date time, which maybe GMT+05, GMT, or GMT-03, we need convert it to logged user's time. For example, given date time is "7/29/2021 2:39 AM GMT+05:00", my local time zone is "GMT+08", I need convert it to local time, the expected result should be "7/29/2021 5:39 AM GMT+08:00". However, I have tried below functions ( image attached ), no one can meet my expectation.

Hi All, I am using regex match to validate some values but after 20.1 upgrade system is very slow & appian support team is saying it is due to regexmatch.  Can regexmatch go to long running process or infinite loop( no loop has been use to in regex ). Any help would be appreciated .

Is is possible to update multiple fields of a CDT using the a!update()? The documentation shows that you can for a regular array, but with the CDT examples shown, it only updates one field at a time. When I test it out in an expression, it throws an error. I just want to check that I'm not missing anything here.  e.g. a!update( data: ri!submission, index: {"StatusID", "SubmissionTypeID"}, value: {1, 2} ) error thrown: Expression evaluation error at function a!update: Invalid index: cannot index multiple indices of type List of Text String into type CRA_T_Submission  

My process model has an integration task that calls an API and then follows up to write into my database, but I keep getting this error when I run it: Cannot index property 'property' of type Text into empty List of Dictionary) (Data Outputs) From what I'm understanding is that the PM can't write a List ({}) to the DB and rightfully so. So in my expression for the output I have this: if( length( rule!myIntegration().result.body.people.person.address ) =0,"", rule!myIntegration().result.body.people.person.address.state.value) I try to tell the expression, that if the List ({}) is empty (or length of 0), then to make it an empty string ("") so it can write an empty string to the DB instead of a List (why the error happens), otherwise if not empty or not 0, to add the value to the DB. I would think this work but I keep getting this error. My JSON API string is as follow: { "people": [ { "id": 1, "person"

I have this expression rule and I need to get the value of one of the keys based upon whether another key property is true or false, I have this but doesn't work: a!localVariables( local!myDictionary: { { item: 1, active: true, description: "Widget", color: "Green"} ,{ item: 2, active:false, description: "another", color: "red"} }, if( fn!index(local!myDictionary,"active","") == true, fn!index(local!myDictionary,"color",null), "") ) To explain further: I would want to return the value "Green" from the key property color due to active property being true and not the value "red" because active property is false.

Hi, So Im trying to get this code to save below into my ri! field but no matter what I do it will not save. Can someone please tell me whats wrong here?

Hello, I have a requirement where I want to use the body present in the XML document as text. And use that text as the rule input value. Is there any way to achieve this? Thanks

if( rule!APN_IsBlank(ri!userOrGroup), "", if( runtimetypeof(topeople(ri!userOrGroup)) = 'type!{http://www.appian.com/ae/types/2009}User', user(touser(ri!userOrGroup), "firstName") & " " & user(touser(ri!userOrGroup), "lastName"), if( runtimetypeof(topeople(ri!userOrGroup)) = 'type!{http://www.appian.com/ae/types/2009}Group', group(togroup(ri!userOrGroup), "groupName"), "" ) ) ) Hello All, Please find the above code ( rule it is to get user or group name ) when you enter a user name it's showing it is  user and when you Test with a group name it's giving me an error  Please look at the code is there any mistake  Thanks in advance 

i am trying index the property "ISOCountryCodeOfIssue", if it is not available in the dictionary (data). We need to default value output. We run the expression , it return back null instead of "BCD" property( { /*ISOCountryCodeOfIssue: "ABC",*/ expiryDate: "10/20/2016", issueDate: "10/20/2011", documentId: "XR58", documentType: "PASSPORT", issuingAuthority: "EN" } ,"ISOCountryCodeOfIssue","BCD") Not sure what am i exactly missing here

How to create an expression rule that returns a list of data from a table in a database?  I already queried in my data using a constant, now I need to create a rule that will returns a list of employee names from a database using the tables primary key (employee_id). 

Hi all, I'm trying to clean up some very messy data by converting text strings representing dates into date objects. The input strings are extracted from various documents (using Appian Document Extraction), so the messiness of the inputs is not something I have control over and cannot be standardized ahead of time. I've found multiple posts on this forum featuring recent recommendations from Appian employee [mention:ab53b06651874f7ba5bfbf12e75aa807:e9ed411860ed4f2ba0265705b8793d05]  to use the value() function for this purpose, so it does seem like this is an expected use case for the function; I'm not trying to do something crazy here. However, the value function does not appear to be working as documented...? This is copied directly from the latest version (21.2) of the official value() documentation on the value() function: Syntax value ( text, [format] ) text: (Text) The string of characters to be converted into a number or date. format: (Text) The

I have a view table which contains 100000 records. What measures are to be considered to obtain faster query results?