Wednesday 23 May 2012

Using Lookup column in CAML Javascript Client Object Model Sharepoint 2010

I had some issues when I was retrieving some records using Lookup in CAML query. This is using JavaScript Client OM. The query should be no different but the Lookup value just didn't work. Well the solution was using LookupId="TRUE".

So the complete query should be –

<query><Query><Where><And><Eq><FieldRef Name='LookupCol' LookupId='TRUE' /><Value Type='Lookup'>itemID</Value></Eq><Eq><FieldRef Name='Title'/><Value Type='Lookup'>test</Value></Eq></And></Where></Query></query> \

1 comment:

  1. I truly like to reading your post. Thank you so much for taking the time to share such a nice information.
    web grid

    ReplyDelete