0

I want to reach list's datas. There is look up column. I am using CAML query. But when i create query with CAML, i am seeing look up column like Microsoft.SharePoint.Client.FieldLookupValue[].I want to see clear datas.

0

Default lookup query uses the value instead of lookup Id.

The typical query looks like :

<Query>
    <Where>
        <Eq>
            <FieldRef Name='RefCountry'  />
            <Value Type='Lookup'>India</Value>
        </Eq>
    </Where>
</Query>

To query by ID you have o setup LookupId='TRUE' attribute of FieldRef element as follows :

<FieldRef Name='RefCountry' LookupId='TRUE' />

Refer this :

  1. FieldRef element (Query)

  2. CAML Query, get item by lookup value, not by ID

  • I have written the query inside my answer but its not showing here, i don't know why...but you can refer this links you will get your your for sure – Ganesh Sanap Sep 28 '17 at 17:12
  • so if i query with id , can i get maltiple values? – f_gulay Sep 29 '17 at 5:40
  • does this answers your question? – Ganesh Sanap Nov 15 '18 at 13:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.