Dynamic SQL Where Clause

[allmendinger]

I have designed an iReport with one parameter $P{WhereClause} and my sql is as follows

 

Select * from qry_StockBalance Where $P!{WhereClause}

 

When I run in iReport the parameter box pops up and I type in

Balance > 1000

Balance < 1000

These both work fine.

 

I upload to JasperServer and add an input control to link to the WhereClause parameter.

 

When I run the report the parameter box pops up and I type in the following

Balance < 1000

This Works

If I type in

Balance > 1000

This does not work and I get the following;

 

The server has encountered an error. Please excuse the inconvenience.

An error has occurred. Please contact your system administrator. (5321)

 

Any help please.

[federico.cattozzi]

It could be useful if you opened the text of the exception and read the cause.

I think it is a limitation of the filter to prevent SQL injection.

Post Edited by helyair at 06/15/2012 08:28