Report Template, get Count of filtered records

danbecker

I'm filtering a repeat in a report template like so, works great. 

${#issues | where:"issue_resolved='Yes'"}

• ${rpt_issue_info_resolved}

${/}

 

Is there a way to add a condition to that filtered repeat, that depends on the count of the filtered records?

Something like this:

${if (issues | where:"issue_resolved='No'" | getValue: "count") > 0}

${#issues}

• ${rpt_issue_info_unresolved}

${/}${/}

 

I keep getting invalid expression...

thanks!

Neal_t_k

Your 'if' condition needs to go inside your repeat tags.  Try something like this:

 

${#issues|where:"issue_resolved='Yes'"}

• ${rpt_issue_info_resolved}

${/}

 

${#issues|where:"issue_resolved='No'"}${if (issues |getValue: "count") > 0}

• ${rpt_issue_info_resolved}

${/}${/}