Hey everyone! I am writing an expression rule to count the rows in multiple task tables so I the user can have the total number of tasks they need to complete on the label for one of the View pages on the record. I have been using a!queryProcessAnayltics().totalcount and I have modeled each of the 8 off of the expression mode code for each of the tables. Unfortunatly I keep receiving 0's when I'm expecting a few on them to have values >=1. Is thre anything right off the bat wrong with my code? Do I need to wrap the code in anything to get the results I want? This is essentially what my code looks like. (I have a rule input called prjId (text value).
a!localVariables(
local!name1: a!queryProcessAnayltics(
report: REPORT_NAME,
contectProcessModel: {LIST_OF_PMS},
query: a!query(
pagingInfo: (start, bath, defualt),
logicalExpression: a!queryLogicalExpression(
operator, "AND",
filters: field: 'c8',
operators: '=',
value: ri!prjId,
)
).totalCount
......
sum(local!name1, local!name2...)
Discussion posts and replies are publicly visible