title: Hibernate Projection on list Field/Attribute and Restricted.in
body: <p>I am have the following product class</p>
  
  <pre><code>productClass
  productID
  name
  make
  title
  colors {1..*}.
  </code></pre>
  
  <p>I'm trying to get </p>
  
  <p><code>productID</code>, <code>colors</code> and <code>name</code> field only..</p>
  
  <p>I product works for single <code>attirbute</code> but <code>colorList</code> wasn't retrieve.</p>
  
  <p>and worst of all.. when I have a criteria (restrictions.in) it says sql is not form properly.. missing attribute y1_</p>
  
  <p>A good example will be</p>
  
  <p><a href="https://stackoverflow.com/questions/4661919/hibernate-criteria-with-projection-not-performing-query-for-onetomany-mapping?rq=1">Hibernate criteria with projection not performing query for @OneToMany mapping</a></p>
  
  <p>I am trying to get the PAYMENT with expenses intact using project where else he is trying to get some fields in expenses</p>