topic Re: Adding repeat query to if statement in ArcGIS Survey123 Questions

Adding repeat query to if statement

TL2 — Wed, 31 Dec 2025 17:49:03 GMT

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?

Re: Adding repeat query to if statement

VenkataKondepati — Wed, 31 Dec 2025 22:56:59 GMT

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${/}

Re: Adding repeat query to if statement

TL2 — Mon, 05 Jan 2026 13:12:45 GMT

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.