AI and Agentic Automation

starting number is 100 & ending number is 200, I need all numbers that contains 5

Hi,In A Bar Chart, Can we display Tooltip value in for example in 1D 1H 1M 1S. Suppose we are getting data in floating 176.5439, and we need to display in 176D 13H 3M 13S. I have converted the value, but a!chartSeries says a!chartSeries accepts only Number (Floating Point) data (List of Number (Floating Point)): Array of decimal data values to display in a chart.

I need to get the admin group in an specific app where the app name is going to be a rule input. Any suggestion? is there anyway to achive it?

Hi All, To display wait time which is waiting for more than a day. We are converting createdDate(date time format) in days and hours. Now, ask is to display the WAIT TIME only when it is more than 1D 0H.But, queryFilter field is createdDate(date time format). In that case how can we display this.Query Filter which I'm using at present  (I know it's not correct), could anyone help me in getting this expression correct.

Hi , I am getting below error the attached code when there I don't pass value for ri!gLLs. Can someone please help in resolving this. "Expression evaluation error at function 'remove' [line 67]: Invalid index (0) for list: valid range is empty" a!localVariables( /* Appending logged in user with GLLS from LUContacts if logged in user is GLL */ local!isLoggedInUserGLL: rule!APN_distinct( if( rule!APN_isEmpty(ri!gLLs), {}, if( and( not( contains( touniformstring( index( a!groupMembers( group: cons!RGRACSLBL_GROUP_AGLL, direct: true(), memberType: "USER" ), "data", {} ) ), touniformstring(ri!loggedInUser) ) ), or( contains( touniformstring(

Hello, How can we get value after an operator for the value which we separate using split function. Eg. 249.5832 Using Split for 249.5832, we can get 249 and 5832. But, I want value after split. If I index with 2, it's getting 5832, but I have to use this for a!forEach for the below expression. For below expression, getting the result as in the image local!calP1days: a!forEach( items: local!P1, expression: if( a!isNotNullOrEmpty(fv!item), split(fv!item,"."),{} ) ) , local!calP1days)

Hi, I have a requirement to update a date based on a condition that if the given date is of last 2 dates of that particular month, then I want my rule to return first date of the next month and it should be applicable for all the dates whether the month has 30 or 31 days or if it is February or leap year. For eg: 27/02/2023 should be converted to 01/03/2023. I have written following code for this, but my senior asks me to optimize the code and reduce the use of if conditions. Please tell me what else I can do edit:a!localVariables( local!currentMonth: month(ri!requestDate), local!currentDay: day(ri!requestDate), local!currentYear: year(ri!requestDate), local!isLeapYear: isleapyear(local!currentYear), todate( if( and( tointeger(local!currentMonth) = 2, or(local!isLeapYear), contains( tointeger({ 28, 29 }), tointeger(local!currentDay) ) ), concat( tointeger(local!currentMonth) + 1, "/

I am trying to perform related action for a record but I am facing below issue  This issue happens for only particular record where as for other records it is working fine. Any help on this would be appreciated

Hi  I am able to extract the document from fillable field in pdf by following the tutorial in forum. I tried to select handwritten notes by holding shift button and select the word but it didn't work for me.  Please guide me to get the tutorial available for handwritten notes. Also is there anything which i have to take care for handwritten notes different than the fillable pdf. 1. I tried to select the work by holding the shift button 2. Preferred vendor - Appian Please guide. Thanks in advance

Hello team, i would like to use an expression rule in timer to define the day when a PM will run based on the values in DB. Every month the cut off day for processes is different and its defined in the DB. The expression rule which i call inside the timer is: =rule!ICH_getCutOffDataByFilters(    year: year(today()),    month: month(today())).day, and it simple calculate the cut off day for current month. But when i publish the PM i am receiving the following error message: ERROR:EVAL:@reason=Expression is invalid (1 token(s) remain after parsing) Any advice please? Thanks

Hi, Im new to using reject function.  Now im using the reject function in a process model in a script task  In the input : I am calculating a map which looks like this :  {    id : <>,    account : <account_cdt(id, name, hold_code)>  } Now in the output tab I want to use reject function to reject all those accounts who have hold codes null ... but then my requirement is that the ID should remain in the output I am using reject function like this :  reject( fn!isnull(_),     a!forEach(           items : ac!map,           expression : {                  id : fv!item.id,                  holdCodes : index(index(fv!item, "account"), "hold_code")           }    ) ) Now I know this wont work, but can anyone suggest me how to make it

Hi, I have a requirement to append the values of a particular computation to a local variable using append function  The rule goes like this :  a!localVariables( local!data : {"x", "y", "z", }, local!finalValues, a!forEach( items: local!data, expression: append( local!finalValues, performSomeComputation(fv!item) ) ) ) now the problem is, the local variable is not getting updated no matter what, I tried using update dictionary as well as insert(local!finalValues, length(local!finalValues) + 1, fv!item) .. but still it wont append .. is there any other method I can use to append values ?

a!localVariables( /* 1 - requestId, 2 - Department, 3 - Sub Department, 4 - Requestor, 5 - Status, 6 - Ship Name, 7 - Task Status */ local!inputList: split(ri!input, "#$"), local!requestId: tointeger(local!inputList[1]), local!deptIdList: tointeger(split(local!inputList[2], "-$-")), local!subDeptIdList: tointeger(split(local!inputList[3], "-$-")), local!requestor: touniformstring(split(local!inputList[4], "-$-")), local!shipId: tointeger(local!inputList[6]), local!statusIdList: touniformstring(split(local!inputList[5], "-$-")), local!taskStatus: toboolean(local!inputList[7]), local!result: a!flatten( a!forEach( items: enumerate(5), expression: a!localVariables( local!batchSize: 2000, local!startIndex: if( tointeger(fv!index) = 1, 1, 1 + ((fv!index - 1) * local!batchSize) ), /*rule!BUS_QE_getBUSReqViewDetails, BUS_QE_getBUSReqVWDtlsTest*/ rule!BUS_QE_getBUSReqVWDtlsTest( fetchtotalcount: t

I have CDT with following fields While using a!toJson , it is EXCLUDING fields which are having NULL values except fields with TEXT datatype. Expresion: -  a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson(local!data)) Result:   Note: If I use parameter removeNullOrEmptyFields as true, it also excluding text fields which are null a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson( value: local!data, removeNullOrEmptyFields: true )) Result: While using a!toJson_17r1, it is returning all the fields of the CDT irrespective of NULL values. Expression: a!localVariables( local!data: 'type!{urn:com:appian:types:RS}RS_dummyCDT'(id: 1, name: "abc"), a!toJson_17r1(local!data )) Result: I want to get the data the way we are getting result while using a!toJson_17r1. i.e. I want to get all the fie

Hi Everyone, I am returning a cursor from Oracle SP, When using new executeStoredProcedureForQuery, i am getting "Invalid Column Type:2012" error.  can see in "Appian Community", Updating ojdbc8.jar solved error, Please advise whether we can follow this solution for our Project.  

Hello folks, in my current solution i use an expression rule which queries a View in DB and returns the data based on filter. The Contract Number is an array of Text type, so far as operator i used "in" which worked perfectly even with multiple values. Now there is a new requirement from the business that instead of using exact values they want to have something like contains ("includes" or "start with"). It works if i change the type from array to single value, but not working with array. Is there any way how to make this work even for array? I am getting the following error message while using array: a!queryEntity_22r2( fetchTotalCount: TRUE, entity: cons!ICH_ENTITY_ICH_V_ContractReferenceData, query: a!query( selection: if( rule!GBL_isBlankOrEmpty(ri!fields), null, a!querySelection( columns: a!forEach( items: ri!fields, expression: a!queryColumn(field: fv!item) ) ) ), logi

Hi All,  I am working on the Appian IDP application. I have trained it on some single-page documents, and it is perfectly working for single-page documents. Now, I have a document that consists of some text fields and a table. The table is starting from page 1 and going up to page 2, but for this document only the single page is getting extraction for the table. I am not able to select the table details from the next page. Can someone else also face this problem, and do we have any solutions for it? Thanks in advance.

Hi All,  I am working on Appian IDP application.  I have trained some single paged documents and it is perfectly working for single paged documents.  Now, I have a document which consists of some text fields and a table, table is starting from page 1 and going up to 2 page, for this document only single page is getting selection for the table. I am not able to select the table details from the next page.  Can someone also face this problem and do we have any solution for this.  Thanks in Advance. 

Hi All ,  I have values stored in database in a particular field i.e. say previousValues, like below  "{"name":"xyz","regDate":"2012-07-01","regStatus":"Completed"}"  --   (Text) Now my requirement is to fetch regStatus value from this format .  How can I achieve this

Hi, I am getting below cast invalid error for below rule. Please help in resolving this. The same code is working fine in one of our environments but not in another environment. "Expression evaluation error at function a!queryEntity_22r2: Could not cast from Boolean to Data Store Entity. Details: CastInvalidCould not cast from Boolean to Data Store Entity. Details: CastInvalid" a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_NEW_PROJECTS_EVENTS_VIEW, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "processId_int", operator: "not null" ), a!queryFilter( field: "isExistingCountry_bool", operator: "=", value: ri!isExistingCountry_bool ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1 ) ), fetchTotalCount:true() ).data

Hi, We have a requirement to generate a document which contains some information of a user that needs to be encoded by the guidelines provided. We need to format the value in such a way that it's length remains fixed always which is provided to us. So any value which has less digits than the required number of digits should be formatted like for eg: If the input is 1250000 and the max limit is 20, then it should be encoded as 00000000000001250000. How can we do that, thanks in advance.

We have integrated the automated rule testing to our CI/CD pipeline. We are using a!startRuleTestsApplications to start the test. We notice on an average the entire test takes under 15 mins to complete, but on occasions the test takes a long time and we ultimately have to kill the build.  Want to know how I can debug this. Unable to find anything in the tomcat logs. Is there any debug log I can enable to check where the test execution is stuck?

Hello guys,We're dealing it some issue on attempting this:Right now with find() function or exact() you can't achieve the following:Let's say we have an e-mail with this phrase "I am an idealist", and on the other hand we have a key defined as: "ideal", right now because the body considers all the text, if you try with find(), the output is true because it finds "ideal" on "I am an [ideal]ist", and the exact() will not work as well because "I am an idealist" is not the same as "ideal", even if the key was "idealist" it will output false as well. Any ideas?

Hi, I have below rule which gives output for distinct values only, but I want get output for indistinct values also. For Ex: If I give rule input for groupId_int as {496,496,498} , I should get output for all 3 values though it repeats for 496 two times. But here I'm getting only for 2 items as below screen shot. Can anyone please help me how to approach  index( a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_APPIAN_GROUPS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "Id_int", operator: "in", value: ri!groupId_int, applyWhen: not( rule!APN_isBlank( ri!groupId_int ) ) ), a!queryFilter( field: "groupName_txt", operator: "in", value: ri!groupName_txt, applyWhen: not( rule!APN_isBlan

Hi, I need to modify time stamp given by caladddays to 12:00AM always. How do I do that. Thanks