0

I am pulling results from a SharePoint Online list without problem with this...

<View><Query><Where><Eq><FieldRef Name='department'></FieldRef><Value Type='Text'>HR</Value></Eq></Where></Query></View>

but this gives me no results (even though there are)

<View><Query><Where><And><Eq><FieldRef Name='department'></FieldRef><Value Type='Text'>HR</Value></Eq><Eq><FieldRef Name='licenses'></FieldRef><Value Type='Text'>yes</Value></Eq></And></Where></Query></View>

Is my syntax wrong?

Thanks P

Improve this question
9
  • Is licences actually a boolean field?
    – Callum Crowley
    Mar 3 at 12:56
  • What is the data type of licenses column?
    – Ganesh Sanap
    Mar 3 at 13:00
  • Single line of text
    – Pete Whelan
    Mar 3 at 13:00
  • Use case sensitive values - check if you are using correct values. Also, verify name of columns just in case
    – Ganesh Sanap
    Mar 3 at 13:03
  • Thanks. Value will always either be blank or yes. I am using the same case. The column name is correct. Totally at a lose with this one!
    – Pete Whelan
    Mar 3 at 13:08

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.