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