AI and Agentic Automation

Is there an way to list all expression rules in an application inside an expression rule itself. Or list all the Appian rules insider a rules folder. My purpose is to find expression rules in an application with and without test cases.

Hi All, We have a Postgre SQL DB connected to Appian system, and we are trying to fetching the data from respective table. i created CDT, entity mapping verified & Data store published successfully. In Rule Expression, when we tried the query entity for this DSE, we are getting below error.  Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [AAFAssetDT2555], query: [queryentity expression], order by: [[Sort[assetpreviousstatus asc]]], filters:[null]) could you please suggest me to resolve the issue.

Hi Team, I have designed an interface which has 1 Rule Input  Now on the UI I am calling an integration and getting data from the integration The requirement here is to save the data coming from the integration to rule input  but without clicking any buttons. i.e. there are no buttons in the interface (if there were buttons I could have used the saveInto parameter of it)  Is there any alternative way to save the data to my RI ?

Hi All I am working on version 23.3. My use case is to extract data from a PDF file; the data can be both hand written or system written. In case the content is system written; after few runs; the system is able to extract certain amount of data from the PDF (which is the expected behaviour from AI Document Extraction). However, if my input PDF document is hand written; no data gets extracted after multiple cycle runs as well. Can any one please guide as to how I can achieve data extraction from hand written document as well or what am I missing to achieve my goal. I am referring to the following link to achieve my goal (Note: Currently trying to capture PDF data in CDT; not in record for my POC): Create a Document Extraction AI Skill - Appian 23.3 Thanks in advance!!

Hi, I have a rule in which I call an SP.I made changes to a field so that it accepts an array and now my Rule is not working.  I'm not getting an error, just nulls. Any idea?with( local!result: a!executeStoredProcedureForQuery( dataSource: cons!SOP_ARC_CONS_ALMACEN_DATOS, procedureName:"SOP_ARC_GETTOTAL_INFORMESLAS", inputs:{ a!storedProcedureInput( name: "STARTINDEX", value: if( isnull( ri!startIndex ), 0, ri!startIndex - 1 ) ), a!storedProcedureInput( name: "BATCHSIZE", value: if( isnull( ri!batchSize ), 100, ri!batchSize ) ), a!storedProcedureInput( name: "SORTBY", value: if( isnull( ri!sortBy ), "idinstancia", lower(ri!sortBy.field) ) ), a!storedProcedureInput( name: "ASCENDING", value: if( isnull( ri!sortBy ), true, tointeger(ri!sortBy.ascending) ) ), a!storedProcedureInput( name: "RESULTADOSMAXIMOS", value: cons!SOP_ARC_INFORMES_MAX_RESULTADO_PANTALLA_ONLINE[ri!codigoInforme] ), a!storedProcedureInpu

Hi Community ,We have a requirement where we have to compare two lists of map , Both the Map have same values but these map are created from different query statement.I want those Keys where Values are different. For Eg : Map1 : [[id:230,no:0]; [id:223,no:1]; [id:232,no:1]; [id:264,no:1]]Map 2 :  [[id:230,no:1]; [id:223,no:2]; [id:232,no:1]; [id:264,no:1]] I need a expression rule which gives result as 230, 223 bcz Map 2 values are different in it. Many Thanks ! Regards,ASK

Hello, I am working on a team that would like to try out and potentially use the AI Skill "Email Classification" for our work, but the training of the AI skill states that it requires .eml files. Unfortunately, our company uses Outlook, which does not natively have a way to save .eml files - as far as I am aware. Is there a way for me to convert .msg into .eml, or has anyone else found a workaround? We are not allowed to use other email providers in any way, and all converters I found online would likely be blocked by my company.

I am facing a weird issue when comparing two arrays of dictionary type. As in the code attached, I have two arrays of dictionary from which I am converting one of them to be similar to other one using foreach loop. I am pretty much sure that output after conversion is same as "array1" in code snippet. But, still their comparison returns {false, false, false} as output of it. And, when I run the commented comparison below, it returns {true, true, true}. Why direct comparison is returning correct output but not the output from foreach besides the fact that formats and outputs are exactly same. a!localVariables( local!array1: { { value1: "abc", value2: "cde" }, { value1: "fty", value2: "yui" }, { value1: "uiu", value2: "dft" } }, local!array2: { { value1: "abc", value2: "cde", value3: "gdh" }, { value1: "fty", value2: "yui", value3: "hyu" }, { value1: "uiu", value2: "dft", value3: "kol" } }, local!convertedArray2: a!forEach( items: local!ar

Hi Appian Community, hope you are doing wellI have the following use case, The solution should be intelligent enough to capture the payslip documents from the end user and extract the data from the payslip document. As with Appian 23.4 release the AI skill has became much more smarter and works like a charm for documents that have similar structure. But, in this particular use case each user can have a different format of payslip that will be uploaded to the system, although all the payslips will be pdf and will be a structured document, but again can vary in terms of format. What is the best way to train the model so it can capture data from these payslips. Also, in case it is not possible can you please suggest a workaround as well.Regards

Hello, How would I go about Base64 encoding a string inside of an expression? In my use case, I have an input to a process model where parameters is a list of type map I would like to wrap local!JOB_ID in a function that converts it to Base64. processParameters: { parameters: { a!map("operationId": 210), a!map("jobId": local!JOB_ID), } } Thank you!

Hi, I have many users and I have custom field 3. I want to get the list of values in the custom field 3.  Is there any function to get the list of specific custom field values? Thanks in advance!

Hi, I have a question regarding exporting users of one project to another. We have one project in one of the environments and the other two in different environments. I want to bring all the two in the same environment, I can export the other two projects but how to export the users of those projects with specified groups they were in one go?

Hello all,We have a requirement to extract the data from the Driving License & Passport images. The catch here is that the user might have clicked it from his phone and sent it to us so We are converting them into PDF but we are not able to extract data from it as it is a semi or unstructured document. Please help if any kind of extraction is possible in such documents.Thanks in advance.

Hi, I have a expression rule which has the result : Name - Company - Phoneno.  I concatenated with "-" when I get the above 3 values. In some cases, the name can be blank / company / phone no. If the name is blank, my result is like  -company-phoneno. If the phoneno is blank, then it's name-company-How to remove the - if the value is not present ?

I have below expression to get the country groups without groups ids. It is working fine when I pass the country name without special characters.  if( rule!APN_isBlank(ri!countryName), {}, a!forEach( items: ri!countryName, expression: rule!APN_replaceNull( nullableValue: group( tointeger(getgroupbyname("RGRACSLBL_" & fv!item)), "groupName" ), replacementValue: group( tointeger( getgroupbyname( "RGRACSLBL_" & stripwith( fv!item, joinarray(cons!RGRACSLBL_SPECIAL_CHARACTERS, "") ) ) ), "groupName" ) ) ) ) But I'm getting below error when I pass a country with special character even though I have special character check in the code. Please help in resolving the error.  For example the country name with special characters : "Bolivia, Plurinational State of", I should get the group name as "RGRACSLBL

Hi, not a problem but following code should throw some error, but it is evaluating.Here a comma is missing, and we are using a local variable in its definition, which should throw an error. Also, we can try various P&C./*Code 1*/ a!localVariables(local!data: 2 * 5tointeger(2 * local!data)) /*Code 2*/ a!localVariables(local!data: 2 * 5tostring(2 * local!data)) /*Code 3*/ a!localVariables(local!data: 2 * 5toboolean(2 * local!data)) /*Code 4*/ a!localVariables(local!data: 2 * 5date(2 * local!data))

Error Message - The Record Data Source did not apply the batch number correctly. The first two responses returned the same data. How and where to fix the issue?

Hi All, I have a scenario where if an expected SLA date&time falls on a non-working day, I need to get next working day value. For example, I have my initial submitted date as 12/27/2023 2:01 PM PST and expected SLA date time based on some biz logic should be 1/2/2024 7:01 AM PST. I have used the below logic but somehow instead of getting the SLA date result for next year as 1/2/2024 7:01 AM PST, I am getting the SLA date result in the same year as 1/2/2023 7:01 AM PST. Please note correct process calendars are used and Dec 30 2023,  Dec 31 2023 and Jan 1 2024 are all set as non-working day. Please help/advise on how I can update to get the correct value:local!finalSLADateTime: if(calisworkday(1/1/2024 7:01 AM PST, local! Calendar),1/1/2024 7:01 AM PST,1/1/2024 7:01 AM PST + (dayofyear(caladddays(1/1/2024 7:01 AM PST, 0, local! Calendar)) - dayofyear(1/1/2024 7:01 AM PST))),

Hi All, I want the output of a workday function to be Date&Time instead of just Date. Please advise on how I can wrap the below logic to get the output as Date& Time:workday( todatetime("01/01/2024 7:01 AM"), ( dayofyear( caladddays(todatetime("01/01/2024 7:01 AM"), 0, "Default Calendar") ) - dayofyear(todatetime("01/01/2024 7:01 AM"))),datetime(2024,01,01) )I need the output to be 1/2/2024 7:01 AM instead I just get 1/2/2024.

I am trying to implement a basic expression rule to determine if a short string is formatted correctly. I have the code below but it returns the error "Keyword Argument unsupported by function contains". I am getting similar errors in other parts of my application so I'd like to figure out what the error means.

Expression evaluation error at function a!update [line 36]: Cannot update List of GAI Workflow at 4 keys; length of assign value list (46) does not match length of the list to update (4). I am getting this error while executing expression rule, How can i fixed that ? i have paste my codea!localVariables( local!currGrantWorkflow: rule!GAI_getWorkflow(workflowId: ri!workflowId).data, local!refDecTree: if( rule!SCO_isBoolNotEmptyAndTrue( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getRefWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{7cd66171-e9d3-45ae-9967-fe88fbd9f594}fkWorkflowTypeStatusId'], taskDecisionId: ri!taskDecisionId ).data ), local!customDecTree: if( rule!SCO_isBoolBlankOrEmptyOrFalse( local!currGrantWorkflow['record

Hi all, is there a way to test for free the AI Copilot functionalities on Appian CE? Thks!

I have an expression rule which returns data for some ID's and for some it returns 0 items. Based on this rule, I need to display a message to the user.If it returns 0 items, then "in progress". If not, the usual data.  How to check if the rule returns some value or 0. I used isnullorempty, but it didn't work

I need to compare two lists of the same type of cdt, and remove any duplicates from one of the lists if two of the fields match. For example CDT Array 1: {type!example( email: "hello@gmail.com", type: 1, date: 05/05/2019 ) } CDT Array 2: {type!example( email: "hello@gmail.com", type: 1, date: 01/01/2022 ), type!example( email: "hello11@gmail.com", type: 1, date: 03/02/2023 ), type!example( email: "hello@gmail.com", type: 2, date: 01/02/2023 ) } In this example, I want to remove CDT 1 from CDT Array 2, because it is has the same email and ID fields as the CDT in CDT Array 1, and I want to return the other two CDTs in CDT Array 2.How can I do this as efficiently as possible?

Hi- Does anyone know on how to implement generative AI with Appian? TIA