AI and Agentic Automation

Hi there, I need to use the date string in format "YMMd", for example, "20220329" for today. I am using the datetext function: datetext(today(), "YMMd"),  if today() function return "03/29/2022", then the datetext(today(), "YMMd") will return "20200328". what's the issue there? why I cant get "20220329"? what's the good way to archive it? Thanks! Lin 

Appian Lovers,  Per Appian Documentation Developers can design the Decision Table and delegate the same to Business Users to add Business Rules. This can be achieved by providing the Editor access to Decision object which will then give them to update the Decision via "Analyst View". Please refer to link below  https://docs.appian.com/suite/help/22.1/Appian_Decisions.html#analyst-view I am not sure, where or how to access the Analyst View. This question is in reference to a request from the Line of Business to figure out if they can manage the Decision Table themselves. Thank you,  Janaki Ram Kavuri 

We have just upgraded our IDP application to current and have found that the modeller needs to be re-trained.  Specifically with the "Invoice with Line Items" document set originally used to train the IDP Classification/Extraction engine.There used to be a zip file (we think we remember one anyway) that contain set of varying documents that fit into this category.  Does anyone have a copy of that (or similar) that they'd be willing to share.

Hi! I'm trying to put logicalExpression within logicalExpression ( one of them will be with operator "AND" and the other one "OR") and I dont know how to write it. Where should I put the logicalExpression with the "AND" operator? for simplify it the "AND" contains the "OR". local!dataSubset: a!queryEntity_18r3( entity: #######, query: a!query( pagingInfo: a!pagingInfo(1,-1), logicalExpression: a!queryLogicalExpression( operator: "OR", filters: { #### }

Hi All, I am sending document to IDP but every time it is "Straight Through Processes" instead of reconciling. Can any one please help me out.

I created an interface to upload a document and i am trying to capture the document name during the upload process. Following is the piece of code for the expression rule that i have been calling in a Script task. a!flatten( a!forEach( items: ri!attachments, expression: if( rule!app_isBlank(fv!item.attachmentType), {}, updatedictionary( dictionary: fv!item, fieldsAndValues: { recordId: ri!actionid, documentName: if( rule!app_isBlank(fv!item.documentId), null(), document(fv!item.documentId, "name") ), documentType: "", modifiedBy: "user@gmail.com", modifiedDt: now() } ) ) ) ) However, i keep getting the following error: Expression evaluation error in rule at function a!forEach [line 2]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'document' [line 14]: Document Does Not Exi

According to docs: a!update() Function - Appian 21.4, this function should work with a list, map, dictionary, cdt or record.  I'm having difficulty with one particular case of a!update with a list of dictionary (version 21.4). I have the following snippet of code and am receiving the following error: This error message is unable to be duplicated with a simple index, meaning the error message is somewhat misleading to myself: Are there any known workarounds - or does this seem like a product issue?  I would rather not have to check if my data type is a list of dictionary prior to calling the a!update function.

Hello all,  I uploaded a document in appian, and now I want to create a some rules regarding some fields.  For instance I want the blank fields to appear under a certain condition. So I want them to appear if they are automatic tasks, in case they re not i don't want them to show.  What's the best practice here

what is the Max limit of  creating rule inputs in an expression or Interface?

Hello, I need to know if it is possible to retrieve the SAIL code from an Expression Rule. The requirement is to update the Sail code of an expression rule using the UPDATE EXPRESSION RULE smart service.

Appian seems to have some kind of issues with TIFF or  JFIF  images, they don't show up in the imagen component, do you know anything about it?, thanksWith PNG or JPG

Hi there, I know I can use any function to check any element is null in an array like this: any(fn!isnull, {0, null, 30}). how to use any function to check if any element is 0? Thank you. Lin

Hi, Could someone clarify my doubt about difference between the usage of the rules APN_isEmpty   and APN_isBlank? It would be good if a simple example is illustrated to make it simple to understand. Thanks Faisal

I am trying to pass a 10 digit number  (7500882768)  as a rule input in my ER and it has to be of integer format only cannot pass it as text or some other format , but it is getting considered as infinity. Is there any way of passing the exact number without it being considered as infinte?

Hi all , I have to generate a table with the help of html . Is there any way to create . Please let me know know the ways

Hi All , I have a query regarding Expression rule .I have DB where isCompleted and IsMandatory fields are there with repect to particular requestID Example: here I want to return only those sites which have isCompleted=1 for all the isManatory=1  in the above example , i must get only requestid =2 

Hi all, I have a scenario where I have to send a multiple links in a Google chat in a single message Message format should be like this RequestNo ।। CreatedDate ।। Links 1।                          Date।     Click here And so on How to achieve this Thanks in Advance

can some one tell me on how to create an expression rule to add an array of numbers without suing sum function

Hi Experts, I have 2 filters, one is custom picker EMPID and another is checkbox to "Show current month data", below are the steps i am performing to filter the data: ->Uncheck the check box & then search for an EMPID which is not of current month so that EMPID result shows up ->Now check the "Show current month data" check box & so that the search result cleared off  ->Again search for the same EMPID number & no result found shows up in when its checked (Working as expected as its not current month EMPID,) ->Uncheck the "Show current month data" check box & then search again for same EMPID    No result found even after page refreshes with  "Show current month data" check box unchecked

This code for check the process variable "gap" Boolean is not working. My sample rule is: if( rule!APN_isBlank(ri!gap),if( like(ri!text,"*GAP*"), ri!gap=true(), ri!gap=false()), ri!gap) I need to check if the pv- gap (boolean) is null or empty, then I have to populate the gap as with checking on the like function Else I need to just display the gap (true/ false) as it is which is not null. Problem: Here when I give null/ empty value for "gap", then the true part is executed. It says simply false, even when the like function gives true value (text contains words "gap"). Please help me to execute this scenario. 

Hello,  I have developed Document Extraction process, the Start Doc Extraction node is working with Google, problem is that it seems the process is not learning. I have summited the same file a few times and each time it is not extracting anything automatically. Any idea if there is any additional setting to be configured in order to remember the manual inputs from previous submits ?

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