I have a CAML query
<Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ "<Contains><FieldRef Name ='OtherUsers'/><Value Type = 'Text'> " + site.CurrentUser.Name + " </Value></Contains>"+ "</Or></Where></Query>
This query is not fetching desired results. Especially the
<Contains> part of the query. The
<Eq> part works fine and it fetches results, but the contains part is not.
Contains part is checking a note field in SharePoint list