SortCriteria defines a list of SortOrder, which contains an attribute name and an order type (ASCENDING or DESCENDING).
For example, locate all Customer objects based on the following criteria:
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);