Thursday, September 5, 2013

SharePoint CAML, Query and filter Lookup Field by ID (select * from Details List where lookup Field ID = value)

- SharePoint CAML,  Query and filter Lookup Field by ID
- Select * from Details List where lookup Field ID =  Value

CAML Query Should be like the following :

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


No comments: