How to order by more than one field in Grails?

by

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')
    }
}

Related Contents:

  1. Why do I get a “Null value was assigned to a property of primitive type setter of” error message when using HibernateCriteriaBuilder in Grails
  2. Difference between findAll, getAll and list in Grails
  3. Checking if a collection is null or empty in Groovy
  4. What are “Groovy” and “Grails” and what kinds of applications are built using them?
  5. Clojure 1.2.1/1.3/1.4 ‘proxy generated in Grails 2.0.0 runtime fails. 1.2.0 is fine
  6. How to change grails localhost port?
  7. Connect to H2 database using IntelliJ database client
  8. Found shared references to a collection org.hibernate.HibernateException
  9. Grails vs Roo – why SpringSource is pushing two very similar technologies?
  10. How to access Grails configuration in Grails 2.0?
  11. Grails BuildConfig.groovy, difference between build, compile, and runtime?
  12. Using “$” in Groovy
  13. How can I return a 404/50x status code from a Grails Controller?
  14. Grails domain class: unique constraint for multiple columns
  15. Bcrypt generates different hashes for the same input?
  16. How can i set default value in grails domain class
  17. Overriding grails.views.default.codec=’html’ config back to ‘none’
  18. Multiple “order by” in LINQ
  19. Posting a File and Associated Data to a RESTful WebService preferably as JSON
  20. MySQL Orderby a number, Nulls last
  21. MySQL order by before group by
  22. How to order by with union in SQL?
  23. how to customize `show processlist` in mysql?
  24. What is the purpose of Order By 1 in SQL select statement?
  25. MySQL: Sort GROUP_CONCAT values
  26. SQL order string as number
  27. How to use SQL Order By statement to sort results case insensitive?
  28. Order a List (C#) by many fields? [duplicate]
  29. How to use Oracle ORDER BY and ROWNUM correctly?
  30. How do I return rows with a specific value first?
  31. MySQL – ORDER BY values within IN()
  32. MySQL: Order by field size/length
  33. Sorting related items in a Django template
  34. How to pass parameters to a modal?
  35. Can I do a max(count(*)) in SQL?
  36. SQL Order By Count
  37. What is the correct target for the JAVA_HOME environment variable for a Linux OpenJDK Debian-based distribution?
  38. MySQL ORDER BY IN()
  39. ORDER BY using Criteria API
  40. How do I order my SQLITE database in descending order, for an android app?
  41. The order of a SQL Select statement without Order By clause
  42. How to configure a session timeout for Grails application?
  43. MySQL order by “best match”
  44. What does “ORDER BY (SELECT NULL)” mean?
  45. Using MySql, can I sort a column but have 0 come last?
  46. SQLite and custom order by
  47. How to order 1,2,3 not 1, 10, 11, 12 in mySQL
  48. PostgreSQL – repeating rows from LIMIT OFFSET
  49. Select the 3 most recent records where the values of one column are distinct
  50. Use own IComparer with Linq OrderBy

Leave a Comment