Tony,
this is very simple. First create a SelectQuery based on the class then pass
it an Ordering object. You have the option to order using the DBMS or once you
have the result set. It is less resource intensive to let the DBMS do it.
SelectQuery query = new SelectQuery(Event.class); // Select Query
query.addOrdering(new Ordering(Event.NAME_PROPERTY,
SortOrder.ASCENDING)); // order by name
Joe
On May 6, 2011, at 2:28 PM, Tony Dahbura wrote:
> I am trying to find an example of using an order by on a cayenne query. I was
> hoping to have it sort the information using the database versus locally
> which cayenne seems to support either.
>
> My example is I need to do a select * from event order by name ascending.
>
> How do I build such a query:
>
> SelectQuery query = new SelectQuery(Event.class);
> //what goes in here to sort by some field in the object to order it
> query.addOrdering();
> List<Event> values = context.performQuery(query);
>
>
> Thanks,
> Tony
>
