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
What do you see when you just view that report, and provide those three process models as context?
What result do you get if you run the QPA query by itself, without filtering on "prjId"?