Hi Tony, SelectQuery query = new SelectQuery(Event.class); query.addOrdering(new Ordering(Event.SOME_PROPERTY, SortOrder.ASCENDING)); List<Event> values = context.performQuery(query);
mrg On Fri, May 6, 2011 at 2:28 PM, Tony Dahbura <[email protected]> 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 > >
