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>
\
I truly like to reading your post. Thank you so much for taking the time to share such a nice information.
ReplyDeleteweb grid