Hi Dave, Since you are seeing deprecation warnings I'm assuming you are using Cayenne 3? If so, you should use:
addOrdering(Ordering ordering) or addOrdering(String sortPathSpec, SortOrder order) These are defined for your SelectQuery object. Of course, if you are using the first of those methods, you'll have to create your own Ordering object first. The second creates one for you behind the scenes. Let me know if you need additional pointers! mrg On Tue, Mar 16, 2010 at 1:11 AM, Dave Dombrosky <dom...@gmail.com> wrote: > Is there any way to use sort expressions in a query? Something like > "ORDER BY column = id"? I get the error "Unsupported ordering > expression" when trying to execute a query with this in it. > > Also, it looks like I might be able to do this using in-memory > sorting, but the Ordering(Expression sortExpression, ...) methods are > deprecated. So what's the preferred way to sort on expressions in > Cayenne? > > -Dave >
