SortCriteria

For example, locate all Customer objects based on the following criteria:

• 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

Use code similar to:

 Query props = new Query();
        //define the attribute based conditions
        CompositeTest innerCompTest = new CompositeTest();
        innerCompTest.setCompositionType(TestType.OR);
        innerCompTest.add (
        new AttributeTest ("state", "CA", AttributeTest.EQUAL));
        innerCompTest.add (
        new AttributeTest ("state", "NY", AttributeTest.EQUAL));
        CompositeTest outerCompTest = new CompositeTest();
        outerCompTest.setCompositionType(CompositeTest.AND);
        outerCompTest.add (
        new AttributeTest("fname", "John", AttributeTest.EQUAL));
        outerCompTest.add (
        new AttributeTest("lname", "Doe" ,AttributeTest.EQUAL));
        outerCompTest.add (innerCompTest);
        //define the ordering
        SortCriteria sort = new SortCriteria();
        sort.add ("lname", SortOrderType.ASCENDING);
        sort.add ("fname", SortOrderType.ASCENDING);
        sort.add ("id", SortOrderType.DESCENDING);
        //set the Query object
        props.setTestCriteria(outerCompTest);
        props.setSortCriteria(sort);
        props.setSkip(10);
        props.setTake(5);
        props.setStateCriteria(ObjectState.NEW | ObjectState.UPDATED);
        com.sybase.collections.ObjectList customers = Customer.findWithQuery(props);