Adding repeat query to if statement

Question

I have an if statement below that produces a "Yes".

${if (1>=0)} Yes${/}

I have a query statement below that produces a "1".

${Inspection | where:"status='Deficient'" | stats:"count, q_2"}

I am unable to place the query inside the if statement without getting errors - mostly unclosed or unopened.

How do I combine the two?

TLongSUGF · Answer

Is there documentation on the assign parameter?  I was not aware that was a thing and do not see any references here: Report queries—ArcGIS Survey123 | Documentation

Thanks for your help.

VenkataKondepati · Answer

In Survey123 report templates you can’t nest a where | stats query inside an if statement because queries are evaluated separately, which causes parsing errors. Instead, run the query first, assign the result to a variable, and then use that variable in the if condition, like this:

${Inspection | where:"status='Deficient'" | stats:"count" | assign:"defCount"}
${if defCount > 0}Yes${/}