current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 2 down vote favorite

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?

share|improve this question

1 Answer 1

up vote 5 down vote accepted

You can use Membership element:

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

http://msdn.microsoft.com/en-us/library/office/aa544234(v=office.15).aspx

share|improve this answer
    
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! –  Daniel Ziga 8 hours ago

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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