Consider a list which has a column of type "Person or Group" (single selection) witch contains a SharePoint group. I want to return all rows for which the group is within a list. I know the IDs of the groups so I am doing this:
<Where>
<In>
<FieldRef Name='GroupColumn' LookupId='TRUE' />
<Values>
<Value Type='User'>1</Value>
<Value Type='User'>2</Value>
<Value Type='User'>3</Value>
</Values>
</In>
</Where>
This works. But how do I write the query for which the column allows multiple selections?
From what I've found it's enough to say <Value Type='UserMulti'>1</Value>
instead of <Value Type='User'>1</Value>
. But this does not work and throws:
Value does not fall within the expected range.
So how do I make the query for the multiple selections field?