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>...

SharePoint Online

Iron Contributor

May 26, 2020

rautchetan27try to use the below format

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

rautchetan27
Brass Contributor
May 27, 2020
Sudharsan K

do I need to put <Where> tag?

<where><Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership></Where>
- Sudharsan K
  Iron Contributor
  May 31, 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>
rautchetan27
Brass Contributor
May 26, 2020
Sudharsan K

I tried following , but its give me syntax error, something is wrong with this CAML query

<Where><Eq><FieldRef Name="Vendor"/><Value Type="Text"><Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership></Value></Eq></Where>
- rautchetan27
  Brass Contributor
  May 26, 2020
  Sudharsan K
  I tried following, its not throwing any error, but also not filtering.
  it showing all list items without filter
  
  <Membership Type=\"CurrentUserGroups\"><FieldRef Name=\"Vendor\"/></Membership>
  - rautchetan27
    Brass Contributor
    May 26, 2020
    Sudharsan K
    
    Can I debug CAML query if we can check correct value coming in Currentusergroups
    How we can check for value

Resources