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("http://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("http://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>.

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

One thought on “SPQuery Returns All of the Items

  • February 25, 2013 at 9:05 AM

    the code is working, but it is not retrieving all items because of the value .

    Reply

Leave a Reply