Skip to main content
October 30, 2023
Question

Expression Rule in task report for column config is not populating the data

  • October 30, 2023
  • 1 reply
  • 0 views

I am calling an expression rule in task report for the context of tasks assigned to owner by creating a new column with "Edit". This newly added column with the expression rule is not populating the data in the report, but the same is working as expected while passing the data.

Below is the code inside expression rule:

a!localVariables(

local!toDate: todate(ri!startTime),

local!days: tointeger((ri!toBeExpireDate) - (local!toDate)),

tointeger(todate(ri!startTime  + local!days) - todate(today())

)

startTime = tp!starttime from the report, toBeExpireDate = process variable (using this for calculating the no.of days left)

Please let me know if the expression rule can be configured for column within the reports. Also, please suggest if there are any other alternatives.

Note: Without calling the rule, I tried with the logic pasted above, but no luck.

1 reply

stefanhelzle0001
October 30, 2023

Process reports do not support expression rules and local variables. You need to restrict you logic to the most basic.

Is there a reason why you don't use the deadline configuration of that task? There is a lot of functions readily available and you don't have to reinvent the wheel.

Find some available process report specific functions here: docs.appian.com/.../Process_and_Report_Data.html