AI and Agentic Automation

We are having a start date Eg. "2022-04-22 18:10:03"(Datatype: Date & Time) . I need to add 5 hours to the date and should provide me result as "2022-04-25 14:10:03". Requirement: Should not include time between 19:01(7:01 pm) to 9:59(am) and week end (Saturday & Sunday). Explanation: 4th April is Friday and the time given was 18:10(6:10pm). Total time taken is 50 min to complete 7pm on 4th April. As 23rd and 24th comes under week ends (Saturday & Sunday) we need to remove those date and time. Then we need to add date from 25th10:00am resulting in adding 4 hours 50 min on 25th.

Has anyone implemented a custom picker that queries all the expression rules in an environment ?

I have a query entity where i am passing date column AA to fetch some info from table. Now based on Source,i need to use different date columns.Example: For Source A i have to pass column DateAAAA, for source BB pass DateBBB etc. I dont find a way to pass the source here. Like if source is A,then do this ...  a!queryFilter( field: "dateFilterXXXX", operator: ">=", value: gmt( todatetime( workday( local(now(), "America/New_York"), -10, ri!holidays ) & " " & totime("16:00 PM") ) ) ), else.... a!queryFilter( field: "dateFilterBBBB", operator: ">=", value: gmt( todatetime( workday( local(now(), "America/New_York"), -10, ri!holidays ) & " " & totime("16:00 PM") ) ) ), I am not passing parameters from any other place into this rule, so i dont find a way to pass the source. I need to get the source first and then define filters accordingly. Please suggest on how i c

Hi!, I need to change the name of a rule input from a expression rule. But this rule it´s called by nearly 20 rules/interfaces in my app. So, is there any way to change all que code quickly from all 20 objects with the new rule input name? the only solution i have is going one by one changing the name. Thanks!

I am getting the below-mentioned error while converting xml to cdt using torecord() function.  Does any one know what is the root cause of this error ?? or Let me know alternatives of converting XML to CDT ? Thanks

I have created expression rule to find data like {{changeid:"1234",prioritystatus:null}} now i want to update this list of dictionary using a!update how can i do that? i want to update that field prioritystatus. I am doing this by selection of one prioritylist in dropdown box. I have done this in user interface and on changing this status it will update the above field in this list of dictionary. But it gives error. I have done like this: a!update (data:{{changeid:"1234",prioritystatus:null}},index:"prioritystatus",value:1)

Hello All, My requirement is to search a word from the sentence. for example: sentence(single text): "The document is AI contain the data"  search text :"AI"     Output: true The desired result is:- get that the sentence is having the search text but only if exact word is there no if that alphabet is any word. For example: "The document  contain the data" search text: "ai". output: false regards sahil

a!queryFilter( field: "expiredDays_int", operator:"between", value: {rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 1 ).startIndex_int, rule!CR_CMU_DSC_getExpiredDaysInSecurityDocumentation( selectedItemType_txt: 31 ).endIndex_int } ) how can write this query without between operator 

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