title: GORM: Find by collection contents
body: <p>I Have the following two classes:</p>
  
  <pre><code>class Person{
  
   String name
  
    static hasMany = [
       items: Item
   ]
  }
  
  class Item{
   String name
  }
  </code></pre>
  
  <p>Multiple Persons can also have the same Item. I'm trying to get a list of all Persons that have a specific item in their collection. I.E. Both Person A and B have Item A in their list so return them both. Unfortunately their is no findAllByCollectionContains() the closest is is findAllByCollection() which requires an exact set.</p>
  
  <p>I've been trying executeQuery to give me a but more control and haven't come up with anything yet.</p>
  
  <p>Example of what I have tried:</p>
  
  <pre><code> Person.executeQuery("select name from Person p where ? in p.items",[item])
  </code></pre>
  
  <p>Any suggestions?</p>