xml / jrxml general question

[yael]

How can I check in the xml file this:

If( $P{status_id} != 0)

then to add WHERE filter.

else

don't use the WHERE

Code:

<parameter name="status_id" class="java.lang.Integer" />
 
<queryString>
<![CDATA[sELECT task_id,status_id FROM tasks WHERE status_id = $P{status_id}]]>
</queryString>

:whistle: