1

This question already has an answer here:

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.

marked as duplicate by Dikesh Gandhi, Gautam Sheth, Robert Lindgren May 3 '17 at 9:43

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

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
    I think you have an extra set of AND tags in there.... – mannaggia May 3 '17 at 9:25

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