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.
Discussion posts and replies are publicly visible
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