Using "OR" sentence in queryFilterString on a domain report?

[uzrk]

I'm creating a domain report with iReport and having a problem with <queryFilterString>.
When I use "OR" sentence in the queryFilterString, it returns an error below:

com.jaspersoft.jasperserver.api.JSExceptionWrapper:java.lang.RuntimeException: exception initting subfilters
       at com.jaspersoft.ji.adhoc.strategy.StrategyAwareDomainQueryExecuter.createDatasource(StrategyAwareDomainQueryExecuter.java:154)
       at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:681)

Can't we use "OR" sentence in queryFilterString?
I'm using iReport 3.7.1.1 and JasperServer  3.7.1.

 

Thanks

Code:

<query> <queryFields>   <queryField id="dim_facility.facility"/>   <queryField id="dim_time.year"/>   <queryField id="dim_time.month"/>   <queryField id="sales"/> </queryFields> <queryFilterString>    (dim_market.market_nm == market_nm_1 OR '1' == market_nm_1_null)    and (dim_scale.scale_nm == scale_nm_2 OR '1' == scale_nm_2_null)    and (dim_product.product_nm == product_nm_3 OR '1' == product_nm_3_null) </queryFilterString></query>

[bbartholow]

I would like to know how to do this as well.  We have two input prompts and need one or the other to be filled in.  How do I write this filter string?

Brian

[rade]

Same problem, How to use "or"?

Radek

[jwatne]

 I am interested in knowing this, as well. I am getting similar Exceptions when attempting to use "or" clauses.

Post Edited by jwatne at 08/25/2011 10:58 AM

[javier.ggi90]

I know it is 5 years later but has anyone found the solution for this?