A!queryProcessAnalytics() keeps returning 0!

Certified Associate Developer

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

Parents Reply Children