Project: Birt
Bug 207889 NOT IN filter of table doesn't work and throws exceptions when preview[07]
Reported: 2007-10-29 21:05:57 | Status: closed fixed

Description: Exception occurs when preview a table with NOT IN filter[07] Build number: 2.3.0.v20071029-0630 Steps to reproduce: 1, New a CUSTOMERS Dataset 2, Drag dataset into layout 3, Select the table and specify a Not IN filter: row["CUSTOMERNUMBER"] Not In 131 4, Preview Expected result: The filter works and preview should be ok Actual result: Exception occurs Error log: The filter definition using expression "row["CUSTOMERNUMBER"]" is not valid. Conditional operator is not supported: 0 data.engine.BadFilterDefn ( 1 time(s) ) detail : org.eclipse.birt.data.engine.core.DataException: The filter definition using expression "row["CUSTOMERNUMBER"]" is not valid.Conditional operator is not supported: 0 at org.eclipse.birt.data.engine.impl.FilterByRow.process(FilterByRow.java:237) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.processFetchEvent(RowResultSet.java:134) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:98) at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:64) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:299) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:271) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:233) at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:73) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:146) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:63) at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.doFiltering(FilterCalculator.java:117) at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.applyFilters(FilterCalculator.java:90) at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.applyFilters(FilterCalculator.java:64)

Files changed in fix:
data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/api/DataAdapterUtil.java data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/internal/adapter/FilterAdapter.java