Filtering Results

You can specify how your results are filtered by using the - (SUPQuery*)having:(SUPTestCriteria*)test method from SUPQuery 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:

SUPQuery *query2 = [SUPQuery getInstance];
[query2 select:@"c.id, SUP(c.id)"];
[query2 from:@"AllType":@"c"];
SUPAttributeTest *ts = [SUPAttributeTest getInstance];
ts.attribute = @"c.id";
ts.testValue = @"0";
ts.operator = SUPAttributeTest_GREATER_EQUAL;
[query2 where:ts];
[query2 groupBy:@"c.id"];

SUPAttributeTest *ts2 = [SUPAttributeTest getInstance];
ts2.attribute = @"c.id";
ts2.testValue = @"0";
ts2.operator = SUPAttributeTest_GREATER_EQUAL;
[query2 having:ts2];