SUPQueryResultSet

Example

This example shows how to filter a result set and get values by taking data from two mobile business objects, creating an SUPQuery, filling in the criteria for the query, and filtering the query results:

SUPQuery *query = [SUPQuery getInstance];
[query select:@"c.fname,c.lname,s.order_date,s.region"];        
[query  from:@"Customer":@"c"];
[query  join:@"SalesOrder":@"s":@"s.cust_id":@"c.id"];
query.testCriteria = [SUPAttributeTest match:@"c.lname":@"Devlin"];
SUPQueryResultSet* resultSet = [SampleApp_SampleAppDB executeQuery:query];
if(resultSet == nil)
  {
    MBOLog(@"executeQuery Failed !!");
    return;
  }
for(SUPDataValueList* result in resultSet)
{
    MBOLog(@"Firstname,lastname,order date,region = %@ %@ %@ %@",
    [SUPDataValue  getNullableString:[result item:0]],
    [SUPDataValue getNullableString:[result item:1]],
    [[SUPDataValue getNullableDate:[result item:2]] description],
    [SUPDataValue getNullableString:[result item:3]]);
}