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>
<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