Forum Discussion

rautchetan27's avatar
rautchetan27
Brass Contributor
May 29, 2020
Solved

CAML query giving error

I want to filter list items on the basis of currentuser group so list items with Vendor column having value same as currentuser group only can see list items

I am using following CAML to achieve this, but I am getting error

 

Vendor is column name in list, which i want to compare with currentusergroup name

 


<Query><Where><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor" /></Membership></Where></Query>

 

do I need to add any other Code, why Membership type=CurrentUserGroups not working for me?

 

whats wrong here, on net i found same solution used by many people and they claiming its working for them

caml
developer
Lists
SharePoint Online
  • Sudharsan K's avatar
    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>

2 Replies

  • Sudharsan K's avatar
    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>

Resources