Jump to content
Changes to the Jaspersoft community edition download ×

xml / jrxml general question


yael

Recommended Posts

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:

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...