CAML query to filter List items on the basis of Current User group in sharepoint

I have List library which having column Name-Vendor, also I have differ sharepoint user groups for each vendor. I am using CAML query to filter List items, so user can see list items belong to its v...

caml

developer

Sudharsan K

May 31, 2020

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>

Sudharsan K

Iron Contributor

May 31, 2020

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>

rautchetan27

Brass Contributor

May 31, 2020

Sudharsan K

Thanks, its working now after makings some changes in column type

Forum Discussion

CAML query to filter List items on the basis of Current User group in sharepoint

Resources