title: hibernate restrictions.in with and, how to use?
body: <p>I have table like below</p>
  
  <pre><code>id, employee_no, survey_no, name
  1    test          1         test_name
  2    test2         1         test_name2
  3    test3         1         test_name3
  4    test4         2         test_name4
  </code></pre>
  
  <p>how to query with Restriction.in by combining below AND into one IN statement?</p>
  
  <pre><code> IN[   (if(survey_no==1)  &amp;&amp; employee_no== 'test')  ,  
         (if(survey_no==1)  &amp;&amp; employee_no== 'test2') ,
          ...
     ]
  </code></pre>