title: Grails - Criteria, exclusive selection
body: <p>I have a domain class containing a 1 to Many relationship. One <code>CreditProvider</code> can have Many <code>Rate</code>s.
  I would like to select all the <code>CreditProvider</code>s that was not rated today with a criteria query (or other if not possible this way), and I am stuck. </p>
  
  <p>Here is the query to retrieve all the CreditProviders rated today: </p>
  
  <pre><code>def criteria = CreditProvider.createCriteria()
  def forgottenCreditProvidersToday = criteria.list {
                  rates {
                          between('dateCreated', dateTodayAtMidnight, dateTodayAndNow)
                  }
              }
  }
  </code></pre>
  
  <p>How could I select the opposite, that is to say the <code>CreditProviders</code> that were not yet rated today ? 
  Also, why do I not manage to eagerly fetch the rates this way:</p>
  
  <pre><code>fetchMode("rates", FM.EAGER)
  </code></pre>
  
  <p>Thank you very much for your help. </p>
  
  <hr>
  
  <p><strong>EDIT:</strong>
  Provisory solution:</p>
  
  <pre><code>def criteria = CreditProvider.createCriteria()
  
          def creditProvidersRatedToday = criteria.list {
              rates {
                      gt('dateCreated', dateTodayAtMidnight)
          }
      order "originalName", "asc"
  }
  def creditProviders = CreditProvider.findAll()
  </code></pre>
  
  <p>creditProviders.removeAll(creditProvidersRatedToday)</p>
  
  <p>I am open to any more elegant solution :)</p>