Is there a way to get a list ordered by two fields, say last and first names?
I know .listOrderByLastAndFirst
and .list(sort:'last, first')
won't work.
Hates_ criteria answer didn't seem to work for me; putting "last,first"
in order will only cause exceptions saying, "Property 'last,first' not found"
. To order on two fields, you can do the following:
def c = MyDomain.createCriteria()
def results = c.list {
and{
order('last','desc')
order('first','desc')
}
}