Forum Discussion

rautchetan27's avatar
rautchetan27
Copper Contributor
May 27, 2020
Solved

filtering list items using CAML query for currentuser group

I am using CAML query to filter list items on the basis of user group.

 

<Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership>

 

but above query not working, do i need to put \ in above query?

if I put \ before Vendor , it throwing error , but no error for \ before currentusergroups

what is purpose of this \

 

and whats wrong with my query? i have created sharepoint group and the granted full access to given list for group , then trying to filter list items on the basis of CAML query and current user group so only list items having value in Vendor column equal to current users sharepoint group can visible to that user?can anyone help 

  • Hi rautchetan27 

    Try to use the below code

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

2 Replies

  • Sudharsan K's avatar
    Sudharsan K
    Steel Contributor

    Hi rautchetan27 

    Try to use the below code

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

Resources