AI and Agentic Automation

Hello everyone,  I have a local variable that query data from data table.The data looks like below:  local!cases: { (clientId: 234,group: 55), (clientId: 600, group: 66), (clientId:234, group: 77), (clientId: 600, group: 88), (clientId: 234, group: 99) } I want to get the group name of only client number 600. Below is my code:  index(local!cases.group,wherecontains(600,tointeger(local!cases.clientId)),null), And got this error:  Invalid index: Cannot index property 'group' of type Text into type List of Number (Integer) Any one got an idea what the reason is? Thanks a lot!

Hi, Is there any function or a recipe to get all the basic users. Please help

Hi, Can Someone help in writing a&nbsp;rule which gives me a list of users whose last login date was a year back. I wrote this rule but it is pulling users with the lastlogin date as null.&nbsp;Please correct me a!forEach( expression: if(todatetime(getuserlastlogin(fv!item)) < ri!datetime,fv!item,""), items: getdistinctusers(cons!PDS_USERS_TYPE) ) Thanks in Advance

Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as&nbsp;Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!

Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022,&nbsp; how to we retrieve the date range like &quot; 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]

How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection

I want to roundup below result to ...upto two places like 3.13....how could i achieve that please help

Hii all, we have 3 teams in my building portal they are 1vendor , 2buyer and 3internal team and the intrnal teams have 3 other sub teams called IT1 and&nbsp; IT2 and IT3,&nbsp; normally when a vendor raised a request&nbsp; for pricing change for a product then it will goes to buyer team , he has the power to reject or accept or send it to internal teams ,&nbsp; now the 1)rule is if the&nbsp; current product price is 10% more than&nbsp;previous price then this&nbsp; should get approval from all the teams from internal teams called&nbsp;IT1 and&nbsp; IT2 and IT3 &nbsp;2) if the the&nbsp;&nbsp;current product price is 10% less than&nbsp;previous price&nbsp;then this&nbsp; should get approval from teams IT1 and IT3 only 3) if retail price is more than cost price then it will get approval from IT2 only note:&nbsp; when buyer forward the request to internal teams above mentioned actions should take place could you please&nbsp; tell me how to achieve this decision mapping and business rules i

Please share any example to write HTML code into the Expression rule&nbsp;

Is it a bug or is there some other reason why my users cannot see records in Tempo or other places when I explicitly gave them permissions in the security configurations? Is anyone else having this problem.&nbsp; I don&#39;t want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.&nbsp; I have given permission on the record type, data store, site, interface ... They still cannot view the record type, even though the tab is visible in Tempo

Hello Team, I need to extract the file extension in a string&nbsp;StoneX - Dist. Agreement -&nbsp;XX Draft 12 Dec 2021.docx. I cannot use the document function to extract the file extension&nbsp;since we have the option to delete/remove the file from repository&nbsp;and this will pop an&nbsp;error &quot;document does not exist&quot;. I&#39;m current using the function&nbsp;getcontentobjectdetailsbyid(todocument(docId)) to extract the name. Is there an easy way to extract the file using an OOTB function? Thanks &amp; Regards Girish Katti

expression evaluation error at&nbsp; &quot;readexcelsheet&quot; readexcelsheet( excelDocument:ri!Spreadsheet, sheetNumber: 1, startRow: 2, ) ruleinput is document

In this rule i had merged two query rule to one new rule, now i want set query filters on this new rule to filter data. Thank You

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? Can anyone please help?

Hello everyone, &nbsp; How to display the table format in appian using expression rules?&nbsp; If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this and data is coming from database.

i have written the expression rule to show the data in table. but how to remove these semicolons from the table&nbsp;a!localVariables( local!contractData: rule!generatecontracttable( cif_int: ri!cif_int ), local!rowItemsdata: { " " & index( local!contractData.value_txt, wherecontains( 1, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 5, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 6, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 7, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & inde

I&#39;m working on a integration project where data is coming out of appian, here I have a situation Where I need to specify if data is missing In a particular field let&#39;s say &quot;name&quot; under &quot;personal details&quot; section then &quot;error type&quot; should be &quot;personal details&quot; and &quot;error details&quot; should be &quot;name&quot;. Likewise I have many fields under section &quot;personal details&quot; - for this i have created a record. Can anyone please help me to achieve this situation

Hello everyone, &nbsp; How to display the table format in appian using expression rules?&nbsp; If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this

here for the fist two filters i want to use it as &quot;AND&quot; operator filters and last two I want use as &quot;OR&quot; operator. Is there any way to do it inside the a!queryrecordtype function?

Hi, I have a string in DB which is: &quot;&lt;key&gt;PROJECT_CODE&lt;/key&gt;&lt;style&gt;BOLD&lt;/style&gt;&lt;color&gt;#EF0010&lt;/color&gt;&quot; and I want your help to split this into different variables, like after splitting the above string&nbsp; var1 will have value = PROJECT_CODE, var2 will have value = BOLD, var3 will have value = #EF0010 Thanks in advance!

Hi All, My scenario is to filter the below view column in appian expression rule using the two rule inputs of &quot;date&quot; dataype(startDate,EndDate), We can see in screenshot, the&nbsp; column is of text and its in concatenated way, is it possible to filter this from appian? Could you please help me on this. Thanks in Advance.

if( isnull(ri!type), {}, a!forEach( items: a!queryEntity( entity: cons!POINTER_TO_DSE, query: a!query( filter: a!queryFilter( field: "type", operator: "=", value: ri!type ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(1, - 1), ri!pagingInfo ) ), fetchTotalCount: true ), expression: if( ri!type = "Text", updatedictionary(fv!item, { textField: true }), if( ri!type = "Decimal", updatedictionary(fv!item, { decimal: true }), if( ri!type = "Date/time", updatedictionary(fv!item, { dateTimeField: true }), if( ri!type = "Integer", updatedictionary(fv!item, { integer: true }), if( ri!type = "Date", updatedictionary(fv!item, { date: true }), if( ri!type = "Boolean", updatedicti

Hi, How can I&nbsp;print the numbers between two numbers. Eg: Number 1 = 1, Number 2 = 5. Expected output 2,3,4 Kindly help. Thanks in Advance

a!localVariables( local!metadataJSON: if( a!isNotNullOrEmpty(ri!metadataJSON), a!fromJson(ri!metadataJSON), null ), local!result: a!forEach( items: local!metadataJSON, expression: a!localVariables( local!section: fv!item, a!forEach( items: local!section.questions, expression: a!localVariables( local!questionrow: fv!item.questionrow, a!forEach( items: local!questionrow, expression: if( fv!item.questiontitle = ri!targetField, updatedictionary(fv!item, { "responsetext": ri!value }), null ) ) ) ) ) ), local!metadataJSON ) I have a nested json. I need to update its field &quot;responestext&quot; if its questiontitle is equal to the parameter. Then return the new json. But the original variable&nbsp;metadataJSON is not updated. Is there an

i tried but i did not get exact output, any one try this .. a!localVariables( local!expression: &quot;x+y-x*y&quot;, local!result: a!forEach( items: enumerate(len(local!expression)) + 1, expression: local!expression[fv!index] ), local!arryIndex: { x: wherecontains(touniformstring({ &quot;x&quot; }), local!result), y: wherecontains(touniformstring({ &quot;y&quot; }), local!result), }, local!etdata: a!update( data: local!result, index: { local!arryIndex.x, local!arryIndex.y }, value: { 10, 20 } ),local!etdata)