Forum Discussion
rautchetan27
May 27, 2020Copper Contributor
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
Sort By
- Sudharsan KSteel 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>
- rautchetan27Copper Contributor