Question

Grails domain的查询方法createCriteria，如果让结果集按两个或两个以上的字段排序呢

def c = Account.createCriteria()
def results = c.list {
like("holderFirstName", "Fred%")
and {
between("balance", 500, 1000)
eq("branch", "London")
}
maxResults(10)
order("holderLastName", "desc")
}
比如最后的order，如何按照holderLastName倒序排之后，再按balance正序排呢？
我知道sql语句是可以按两个及以上的字段排序的，但是不想用sql语句。

Answer 1

用插件。现在这方面的插件很多，可以到官网上找

Answer 2

def c = Account.createCriteria()
def results = c.list {
like("holderFirstName", "Fred%")
and {
between("balance", 500, 1000)
eq("branch", "London")
}
maxResults(10)
order("holderLastName", "desc")
order("balance", "desc")
}