Re: descending order query

Shash Chatterjee <[email protected]> Wed, 11 Aug 2004 20:01:04 -0500
Newsgroups gmane.comp.java.keel.user
Message-ID <[email protected]>
Lou,

> I'm assuming there's got to be an easy way to do this, but I don't see
> it in the docs...you can sort on a column when running a persistent
> query with p.query("sortColumn") but how do you do anything more complex
> than that, like sort on multiple fields or sort in descending order? Is
> it not yet implemented in the default persistence service?

The sortkey argument can be a comma-separated list of fields.  I think, 
the sort order can be specified with the DESCENDING SQL keyword.

So: query("fieldOne, fieldTwo DESCENDING, fieldThree");

Shash