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>
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>
the code is working, but it is not retrieving all items because of the value .
ReplyDelete