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. <Where><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor" /></Membership></Where> what i want, for particular user(X1234) i want to show all list items. <Where><Or><Membership Type="CurrentUserGroups"><FieldRef Name="Vendor" /></Membership> <Eq><UserId Type="Text"><Value Type="text">X1234</Value></Eq></Or> </Where> but its not working, whats wrong with this query?