1

Below CAML query is working for filtering the list items with one column, I have tried to add another column to filter it but facing some errors.

"<View Scope='RecursiveAll'><Query><Where><In><FieldRef Name="OID" /><Values><Value Type="Text">749</Value><Value Type="Text">748</Value><Value Type="Text">598</Value><Value Type="Text">106</Value></Values></In></Where></Query></View>"

I want to filter it again with one more column with some values.

0

2 Answers 2

1

[This question is duplicated with the following one]

Here is your answer,

Sharepoint CAML Query IN operator

1

This should work

<Where>
<And>
    <In>
        <FieldRef Name="OID" />
        <Values>
            <Value Type='Text'>1</Value>
            <Value Type='Text'>2</Value>
        </Values>

    </In>

    <In>
        <FieldRef Name="SecField" />
        <Values>
            <Value Type='Text'>3</Value>
            <Value Type='Text'>4</Value>
        </Values>
    </In>
</And></Where>
1
  • 1
    I think you have an extra set of AND tags in there....
    – mannaggia
    May 3, 2017 at 9:25

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