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?