title: Grails Where Query With Multiple Sort Fields
body: <p>I can't find an example in the doc and I would prefer to use the nifty "where" functionality instead of the "criteria builder" functionality.</p>
  
  <p>I have my "where" query:</p>
  
  <pre><code>def query = Nhrdist.where
  {
      nhrdistPidm == pidm
      nhrdistFundCode == fundCode
      nhrdistCategoryCode == 'A'
      nhrdistAcctCode in ['20L0', '20L2', '20L3', '20L4', '20L5']
      nhrdistTransDate in fiscalYearBeginDate..fiscalYearEndDate
  }
  </code></pre>
  
  <p>And the following works when I sort by one field:</p>
  
  <pre><code>def results = query.list(sort:'nhrdistAcctCode')
  </code></pre>
  
  <p>But I cannot for the life of me figure out how to sort by two fields. I would like to sort by nhrdisAcctCode first, and then sort by nhrdistTransDate. I can't find any examples on <a href="http://grails.org/doc/2.3.x/guide/GORM.html#whereQueries" rel="nofollow">http://grails.org/doc/2.3.x/guide/GORM.html#whereQueries</a></p>
  
  <p>Can someone:</p>
  
  <ol>
  <li>Provide me an example that shows how to sort with multiple fields OR </li>
  <li>Belittle me and point out in the doc where it says I can't do this OR   </li>
  <li>Belittle me and give me the link to a StackOverflow page that answers my question OR </li>
  <li>Tell me to quit my whining and just use a Criteria Builder query.</li>
  </ol>