Bug 207889 NOT IN filter of table doesn't work and throws exceptions when preview[07]
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)
data/org.eclipse.birt.report.data.adapter/src/org/eclipse/birt/report/data/adapter/internal/adapter/FilterAdapter.java
/*
 *************************************************************************
 * Copyright (c) 2006 Actuate Corporation.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *  Actuate Corporation  - initial API and implementation
 *  
 *************************************************************************
 */ 
package org.eclipse.birt.report.data.adapter.internal.adapter;
import java.util.List;
import org.eclipse.birt.core.data.DataType;
import org.eclipse.birt.data.engine.api.querydefn.FilterDefinition;
import org.eclipse.birt.report.model.api.FilterConditionHandle;
import org.eclipse.birt.report.model.api.elements.DesignChoiceConstants;
/**
 * A report filter
 */
public class FilterAdapter extends FilterDefinition