Friday 10 May 2013

How to Use Lookup Column with Multiple Values in CAML?

Lookup Field with Multiple Values

<Where><In><FieldRef Name='Name' LookupId='TRUE'/>
  <Values>
       <Value Type='Integer'>1</Value>
       <Value Type='Integer'>3</Value>
       <Value Type='Integer'>3</Value> 
  </Values>
</In></Where>

Lookup Field with Single Value

<Where><Eq><FieldRef Name='Name' LookupId='TRUE' /><Value Type='Lookup'>1</Value></Eq></Where>

No comments:

Post a Comment