0

I have the following CAML query inside our SharePoint online site collection, to get all the list items which have a choice field named CustomerOrderAlert = No, as follow:-

 List customerliveorderlist = omsWeb.GetList(web.ServerRelativeUrl + "/lists/CustomerLiveOrder/"); CamlQuery query1 = new CamlQuery(); query1.ViewXml = @"<Where><Eq><FieldRef Name ='CustomerOrderAlert'/><Value Type='Choice'>No</Value></Eq></Where>"; ListItemCollection c = customerliveorderlist.GetItems(query1); context.Load(c, items => items.Include( item => item["OrderLiveDeliveredDate"], item => item.Id, )); context.ExecuteQuery();

but i am getting all the items even the ones which have their CustomerOrderAlert = Yes? any idea? Thanks

Improve this question

1 Answer 1

Reset to default
3

You need to add View and Query element to your query. Try below

query1.ViewXml = @"<View><Query><Where><Eq><FieldRef Name ='CustomerOrderAlert'/><Value Type='Choice'>No</Value></Eq></Where></Query></View>";
Improve this answer
0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.