Complex Example

• FirstName = John AND LastName = Doe AND (State = CA OR State = NY)
• Customer is New OR Updated
• Ordered by LastName ASC, FirstName ASC, Credit DESC
• Skip the first 10 and take 5

SUPQuery *props = [SUPQuery getInstance];
// Define the attribute based conditions.
// Users can pass in a string if they know the attribute name. R1 column name = attribute name.
SUPCompositeTest *innerCompTest = [SUPCompositeTest getInstance];
[innerCompTest setOperator:SUPCompositeTest_OR];
[innerCompTest add:[SUPAttributeTest equal:@"state":@"CA"]];
[innerCompTest add:[SUPAttributeTest equal:@"state":@"NY"]];
    
SUPCompositeTest *outerCompTest = [SUPCompositeTest getInstance];
[outerCompTest setOperator:SUPCompositeTest_OR];
[outerCompTest add:[SUPAttributeTest equal:@"fname":@"Jane"]];
[outerCompTest add:[SUPAttributeTest equal:@"lname":@"Doe"]];

[outerCompTest add:innerCompTest];
    
// Define the ordering:
SUPSortCriteria *sort = [SUPSortCriteria getInstance];
    
[sort add:[SUPAttributeSort ascending:@"fname"]];
[sort add:[SUPAttributeSort ascending:@"lname"]];

// Set the Query object:
props.testCriteria = (SUPTestCriteria*)outerCompTest;
props.sortCriteria = sort;
props.skip = 10;
props.take = 5;

SUPObjectList * customers2 = [SUP101Customer findWithQuery:props];