Forum Discussion

Brass Contributor

Jul 10, 2020

CAML query with OR condition

I have following CAML query to filter list items on the basis of Sharepoint group of users. it allow only display list items which have value in Column Vendor equal to Sharepoint group name of user....

Iron Contributor

Jul 13, 2020

rautchetan27

Try to use the below

<Where>
    <Or>
        <Membership Type='CurrentUserGroups'>
            <FieldRef Name='Vendor' />
        </Membership>
        <Eq>
            <FieldRef Name='Vendor' />
            <Value Type='Text'>X1234</Value>
        </Eq>
    </Or>
</Where>

rautchetan27
Brass Contributor
Jul 13, 2020
Sudharsan K

I dont want to compare field/column, what i want if User is X1234 , it should show all items, no filter apply on the basis of membership thats why i want to use <OR>