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

uzrk

Members
  • Posts

    1
  • Joined

  • Last visited

uzrk's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  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...