I have multiple lists with the same custom Person or Group column CurrentReviewer (single selection) which will always contain a SPGroup.

I have set up a SPSiteDataQuery but I'm missing the last piece of the puzzle in my CAML and that is to identify the groups that the current user is part of.

How can I, using CAML query, find all the rows in a list where a group the current user is a member of appears in the column CurrentReviewer?

1 Answer 1


You can use Membership element:

  <Membership Type=\"CurrentUserGroups\">
    <FieldRef Name=\"AssignedTo\"/>
    <FieldRef Name=\"CurrentReviewer\"></FieldRef>
    <Value Type=\"Integer\">


  • I came across this before where it didn't work when I tried. Might have been a cache-bummer on my end. Thanks for the answer!
    – user2536
    Oct 2, 2014 at 11:33

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.