Grails-2.1.3 Criteria Sorting

Grails Criteria Sorting

DESC all Caps is not working in Grails-2.1.3 Criteria


import com.company.User

User.withCriteria{
  eq ('username', 'dev')
  order('username', 'DESC') //use Lower case instead
}.each{println it.name}

println "========================================================="
String hql = """
FROM User as u
WHERE u.username =:name
ORDER BY d.username DESC
"""
def list = User.executeQuery(hql, [name: 'dev'])

list.each{
 println  it.name
}