kwizcom banner advertisement

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 is: This above code returns all items in the list, but if you remove the <Query> tag all works fine:

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);

Remember, Query XML is case sensitive! So <Where> is not equal to <where>
SPQuery Returns All of the Items SPQuery Returns All of the Items Reviewed by Salaudeen Rajack on August 31, 2010 Rating: 5

1 comment:

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

    ReplyDelete

Please Login and comment to get your questions answered!

Powered by Blogger.