Filter Example

Filter Example

    ...

    //Conditions list 
    List l = new ArrayList();

    //field1 > value
    Condition cond = new GreaterThanCondition(value,
                    field1 index, field1 name);
    //field2 = value2
    Condition cond1 = new EqualCondition(value2,
                        field2 index, field2 name);
    //Populate list
    l.add(cond);
    l.add(cond1);

    // field1 > value AND field2 = value2
    AndConditions a = new AndConditions(l);

    // create new rowset with filtered data
    rs1.beforeFirst();
    CompressedRowSet rsFilter = ((CompressedRowSet) rs1).filter(a);

    ...