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


Ads by Google