Filtering Results

You can specify how your results are filtered by using the Query.having(com.sybase.persistence.TestCriteria) method for queries using GroupBy. For example, limit your AllType MBO's results to c.id attribute values that are greater than or equal to 0 using:

Query query2 = new Query();
query2.select("c.id, SUM(c.id)");
query2.from("AllType", "c");
AttributeTest ts = new AttributeTest();
ts.setAttribute("c.id");
ts.setValue("0");
ts.setOperator(AttributeTest.GREATER_EQUAL);
query2.where(ts);
query2.groupBy("c.id");

AttributeTest ts2 = new AttributeTest();
ts2.setAttribute("c.id");
ts2.setValue("0"); 
ts2.setOperator(AttributeTest.GREATER_EQUAL); 
query2.having(ts2);