Skip to main content
1-Visitor
April 6, 2021
Question

How can we add query filter in report recipe?

  • April 6, 2021
  • 0 replies
  • 869 views

We need to query filter in a report recipe, is there a way we can implement it?

Below is a piece of code:

 

<%begindetail%>

<tr>
<th style="background-color:#60607A;color:#FFFFFF;font-weight:bold;text-align:left">States</th>
<td style="background-color:#F5F5F5;text-align:center"><%compute%>('IsEmpty(Query("<QueryName><Filter needed in this query for a particular field>>",sum("<fieldName>"), 0)')<%endcompute%></td>
</tr>