AI and Agentic Automation

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

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.  I don't want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.  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 StoneX - Dist. Agreement - XX Draft 12 Dec 2021.docx. I cannot use the document function to extract the file extension since we have the option to delete/remove the file from repository and this will pop an error "document does not exist". I'm current using the function getcontentobjectdetailsbyid(todocument(docId)) to extract the name. Is there an easy way to extract the file using an OOTB function? Thanks & Regards Girish Katti

expression evaluation error at  "readexcelsheet" 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,   How to display the table format in appian using expression rules?  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 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'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's say "name" under "personal details" section then "error type" should be "personal details" and "error details" should be "name". Likewise I have many fields under section "personal details" - for this i have created a record. Can anyone please help me to achieve this situation

Hello everyone,   How to display the table format in appian using expression rules?  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 "AND" operator filters and last two I want use as "OR" operator. Is there any way to do it inside the a!queryrecordtype function?

Hi, I have a string in DB which is: "<key>PROJECT_CODE</key><style>BOLD</style><color>#EF0010</color>" and I want your help to split this into different variables, like after splitting the above string  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 "date" dataype(startDate,EndDate), We can see in screenshot, the  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 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 "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there an

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

Hello, I am learning query entities and I am getting the warning message (missing domain prefix).  cons!UA_DSE_STUDENTSINFO is mapped to UA_Students DB. I believe it is configured properly because I use the same constant to write values to DB. I am getting the same warning message when I try to use sorting. 

I need an expression which finds corresponding value based on ranges: Input:x{v1,v2,...,vn+1}{r1,r2,...,rn} Result:if (x<=r1) then v1else if (x<=r2) then v2....else if (x<=rn) then vnelse vn+1 Thanks

Hi folks, I have a requirement like display the number of resignation cases per quarter and the data in grid format. Facing issues to fetch data by quarterly. Please help me on this, Thank you. 

I want to set up configure or flow to process multiple if conditions. If(condition= true and condition2=true), true, false) Takes a specific path if condition is true. Wanted to know if it was possible

While trying to check an empty map, a!isNullOrEmpty and a!isNotNullOrEmpty are not working, rather giving opposite result.  The result of a!isNullOrEmpty(a!map())should be true but the function is returning false. Not sure if this is a bug but something that might need the engineering team's attention. [mention:6b9f80ff18f9420082d13ef2d5121d56:e9ed411860ed4f2ba0265705b8793d05]

A,                                             1 BC,                                          2 DEF,                                        3 GHIJ,                                       4 KLMNO                                   5 ---------                                     -- A to Z                              &nbsp

Hi everyone, I've a task that say: Convert 12/12/21 to December 12, 2021 and he gives me this hint Hint: You need to use two Appian functions: text() and datevalue() this is the task on the image below. can anyone would help me to do this task.