SPQuery Returns All of the Items
During a development project, calling SPQuery returned all items from list! Looks like it just ignored the filters we applied.
SPList list = new SPSite("https://MySharePointSite").OpenWeb().Lists[listName];
SPQuery query = new SPQuery();
query.Query = "<Query><Where><Eq><FieldRef Name="Title" /><Value Type="Text">Test</Value></Eq></Where></Query>";
SPListItemCollection items = list.GetItems(query);
Fix:
This above code returns all items in the list, but if you remove the <Query> tag all works fine: “<Query><Where><Eq><FieldRef Name=”Title” /><Value Type=”Text”>Test</Value></Eq></Where></Query>“;
SPList list = new
SPSite("https://MySharePointSite").OpenWeb().Lists[listName];
SPQuery query = new SPQuery();
query.Query = "<Where><Eq><FieldRef Name="Title" /><Value Type="Text">Test</Value></Eq></Where>";
SPListItemCollection items = list.GetItems(query);
Remember, Query XML is case sensitive! So <Where> is not equal to <where>.
the code is working, but it is not retrieving all items because of the value .