thanks!
----- Original Message ----- From: "Joe Baldwin" <[email protected]> To: [email protected] Sent: Friday, May 6, 2011 2:46:33 PM Subject: Re: Example of an order by clause on a query 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 >
