Jump to content
We've recently updated our Privacy Statement, available here ×

uzrk

Members
  • Posts

    1
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Everything posted by uzrk

  1. 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>
×
×
  • Create New...