AI and Agentic Automation

We often use a!update() function to update dictionary values however, it fails when a dictionary has 2 attributes with different font cases (e.g. label & LABEL) In 21.4 I tried using the a!update() function as below: Input:  { label:"", LABEL:"asdf", label3:"", label4:"asdf"} Rule:  a!update(ri!dict,"LABEL",123) Output:  {label: 123, LABEL: "asdf", label3: "", label4: "asdf"} Is there another function that I can use to avoid this? I do not want to recreate the entire dictionary each time someone updates a single value.

Hi All, I am facing an issue both in expression rule and in oracle database but I am confused like what will be  the reason for this issue. Issue in expression rule: I just want to query data from database and it runs fine for all task id. But it shows me error only for the task id #141. Issue in Oracle database: When I try to retrieve data in one particular view for task #141 it takes more time(more than 5 minutes) to load even for 2 rows but at last the output comes. But when I try for some other task id it takes time less than a minute even it has 1000 rows. Note : The entity I used in expression rule and the view I ran in oracle database are same. Only for task #141 this issue occurs. We checked process instances, it doesn't show any error. Because of the above issue the users are not able to open the task 141 in site, since it loads for several minutes and then loading pauses then loading disappears. Please help me to sort this issue. Thanks in Advance.

Hi all, i have two question  1.can we select the dynamic operator :           for eg : if(1 ri!operator 2,"if true","if false")               where operator will belike {">=","<","=",etc..} . which user select from site 2. can apply a query filter on an aggregated column  eg: a!query( aggregation: a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "zipcode", isGrouping: true ), a!queryAggregationColumn( field: "caseId", alias: "caseId_count", aggregationFunction: "COUNT" ) } ), logicalexpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "caseId_count", operator: "

Hi, When I debug a process instance, I can see the value changed of my var in the Process history tab of a Process instances. Example : [unit_id=976, info_data= [quantity=50, fk_line_id=, data=[test1=2, test3=3],[test1=4, test3=6]]] Does Appian provide a native way to convert this string to a String expression ?  (replacing "[" by "{",  "=" by ":"  etc ...) A little java program would make the stuff... but I'm just curious about a way inside Appian (maybe using some json functions). Regards

Hi All,  I have a condition where I want to show a user profile photo if it is there otherwise show initials.  For Image , I am using a!Image and for Initials I am using a!stampField.  Can i use these two together so that if user profile is not present than I can show Initials. Thanks In Advance, Saurabh

I saw that there is a provision for getting multiple values (array) as output from a decision objects. But, how to configure that? Eg. In my decision If I want List of 4 text strings {A,B,C,D} for Input Integer 1, but when I configure output with comma separated values A,B,C,D It is returning a single string "A,B,C,D". Please see screenshot below: Can someone help? Is there any way to achieve this? Or is making hit policy as Rule first the only way possible to get a proper list output from decision? NB: I DON"T WANT MULTIPLE OUTPUT> I WANT SINGLE OUTPUT AS AN ARRAY!!!

Hi All, I tried to fetch data from Database using queryEntity in expression rule. But due to large data in database(6278),it shows me the below error. Could you please help me to sort this issue. Thanks in advance.

We have been using IDP for a month now and we've built up a significant amount of data for our model, now we want to back up our models to another environment so as to have redundancy in case of complete failure on one of the environments, is there any way we can export our trained models for an IDP in another environment?

Hello, I'm reading a record that contains a text field I'd like to have listed in an array. However, the array should only have unique values, so if that text is already in there, I don't need to add it again. I've written this.  a!localVariables( local!arrayOfMakes, a!forEach( items: a!queryRecordType( recordtype: recordType!KD VM Vehicle, fields: recordType!KD VM Vehicle.fields.make, pagingInfo: a!pagingInfo( startindex: 1, batchSize: 50) ).data[recordType!KD VM Vehicle.fields.make], expression: if( contains(local!arrayOfMakes, fv!item), null, append(local!arrayOfMakes, fv!item) ) ) ) It returns what I think I need, but it's not unique. Here's part of the output. Further down you would see that it has several entries for the same make.  All ideas are appreciated!

Hi All, In my  application, I have to use caladddays() function which calculates only the net work days and for daylight boundaries. So for 72 hours, I will use caladddays(ri!date,3) ,  it works fine.(where ri!date = 1st November 2021,10:00 AM) But the user wants to pass the 2nd parameter by constant and he wants to test for 1 hour by changing the constant value. If I use caladdhours,the outputs are different  from caladddays, PFA the below screenshots, If there is anyway to pass hours in caladddays function, can you please help me? Thanks in advance. Regards, Jansi J

Created below table in appian DB Create a CDT and a DataSet. Now I got struck while creating expression rule. Can someone help here. I want to bring id, Name from language table and show the data in a dropdownlist. choiceLabel with "Name" column data choiceValues with "id" column data.

a!localVariables( local!locationsList:rule!AT_getAddresses(addressId: null), -- getting an error at this line.{ a!sectionLayout( label: "Address", contents: { a!radioButtonField( label: "Radio Buttons", labelPosition: "COLLAPSED", choiceLabels: local!locationsList, choiceValues: local!locationsList, saveInto: {}, choiceLayout: "STACKED", validations: {} ) } )})

Hello,  I would need the result of this Expression Rule in cod_provincia show me only the code of the provincia to which the municipio belongs. However, it is returning all the codes from my provincias table.  What am I doing wrong? Thanks in advance. 

Hello! I am making a call to an integration to retrieve data that I am saving in a local variable. then I have another local variable with a parent cdt. And now I want to save my integration data in my son cdt. How can I cast my data to follow the format of my database and have in my child CDT a column of my parent CDT? I need to use whereContains? I am learner. Thanks !

Hi team, i have an expression rule to get the doctors with count of patients assigned to them with the disease but i want to get the  total patience count for that particular doctor with array of disease like eg: swift:3:{cance,Gallstones,Emotional Disorder}, Please help me to achieve this format substitute(substitute(substitute(substitute( substitute( substitute( a!queryEntity( entity: cons!PO_MEDICALINFO, query: a!query( logicalexpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "reasonForVisit", operator: "in", value:ri!reasonForVisit ), a!queryFilter( field:"appointmentDate", operator: "between", value: { todatetime(ri!createddatefrom), todatetime(ri!createddateto) }, applywhen: and( not(rule

Hi. I added some new document types in Standard Channel and I wanted my model to auto classify the document. I tried many times but did not get any email from Appian regarding Classification of the documents. I just wanna ask, is the feature to train documents for auto-classification even available for Appian community edition users?

We have got an email box ( for example : Customercare@xyzcompnay.com). There are thousands of emails here related to customer issues like  Email 1 : "internet is very slow" Email 2 : "have a query regarding refund" .etc. Email X: "Would like to change my personal details". I would like to create a process which reads the above emails and creates tasks based on keywords.  This process has to create as task for Finance team with Email2 as it is related to Refund. And it has to create another task for IT team with Email1 data as it is related to Internet and so on another task to HR Team with Email X. I assume it is more of a AI ( Machine learning ) work.  Is there any way to do this in Appian ? Thanks

Is there a way to authorize the carriage return when using the cleanwith() function? I tried to include char(10) or char(13) at the end of the "with" parameter, but the result is not what I expected. Examples: ri!myText: "My texte with carriage return" cleanwith(ri!myText,"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ "&char(10)) Result > "My texte with carriage return" cleanwith(ri!myText,"abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ "&char(13)) Result > "My texte with carriagereturn"

Hi All, We wrote a query to fetch  date from one particular entity from Database, but the output(date) differs based on the user time zone. For example , In Database it shows as 10th June 2021,12:06 AM, For GMT time zone user it shows as 10th June 2021,12:00 AM as output in expression rule, For EST time zone user it shows as 9th June ,8:00 PM as output in expression rule. Can you please help us to sort this, Thanks in Advance. Regards, Jansi J

When i add process model to navigation bar it works fine but then i collap the navigation bar it show blank on icon click  how to add process model to section layout? a!sectionLayout( contents: { rule!TCT_Template_Dashboard() } ), a!sectionLayout( contents: { } ),

Hi All,  I have a column  name created date in db as datetime . When I am creating filter in expression rule as createddatefrom and createddateto . I am not able to filter it .  Expression Rule: a!queryFilter( field: "createddate", operator: "between", value: { todate(ri!createddatefrom), todate(ri!createddatefrom)+ day() }, applywhen: not(rule!APN_isEmpty(ri!createddatefrom)) ), a!queryFilter( field: "createddate", operator: "between", value: { todate(ri!createddateto), todate(ri!createddateto) + day() }, applywhen: not(rule!APN_isEmpty(ri!createddateto)) ), Please help and thanks in Advance

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