title: ADF: fail to operate IN in view criteria
body: <p>The where clause which contains IN operation should be like: Id in ()</p>
  
  <p>For example, where Id in (1,2,5,8)</p>
  
  <p>My code as follows,</p>
  
  <pre><code>ViewCriteria vc = vo.createViewCriteria();
  ViewCriteriaRow vcRow = vc.createViewCriteriaRow();
  ViewCriteriaItem vci = vcRow.ensureCriteriaItem("Id");
  ArrayList&lt;ViewCriteriaItemValue&gt; valueList = new ArrayList&lt;ViewCriteriaItemValue&gt;();
  
  for (int i = 0; i &lt; 3; i++) {
     valueList.add(new ViewCriteriaItemValue(vci, values.get(i), false, false, i)); 
  }
  vci.setOperator(JboCompOper.OPER_IN);
  vci.setValues(valueList);
  vci.setConjunction(vcRow.VC_CONJ_AND);
  vcRow.add(vcRow);
  </code></pre>
  
  <p>Debugging shows that the values have been set to vci but the results show it applies only the first value to Id.</p>
  
  <p>Can anyone help with this?</p>