Forum Discussion

Brass Contributor

May 25, 2020

Filtering List Item using CAML query in sharepoint

I want to filter list items on the basis of Current user sharepoint group, so only list items having value in column same as sharepoint group name can display I am using CAML query <Where><Eq>...

Steel Contributor

May 25, 2020

rautchetan27try to use the below format

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

rautchetan27

Brass Contributor

May 26, 2020

Sudharsan K

do I need to put <Where> tag?

Sudharsan K

Steel Contributor

May 30, 2020

rautchetan27

I am really sorry for the delay, can you try using the below code

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