Looking for something?

If you’ve ever used the SPQuery objects to get SPListItems from a SPList, and you didn’t get it to work because the query would return ALL items in the SPList, you might have used code similar to this:

SPQuery postsQuery = new SPQuery(); postsQuery.Query = string.Format(     ""+        ""+           "" +        ""+        ""+           ""+              ""+              "{0}"+           ""+        ""+     "", threadID);

SPList allPosts = SpecificForumData.GetPostList(); // Custom method to get the SPList object SPListItemCollection posts = allPosts.GetItems(postsQuery);

I’ve always built my queries by hand (what better way to learn than trial and error, right?), but when I tried the U2U CAML Query Builder to construct my SPQuery it suddenly all failed, and all items in the SPList was returned.

To solve this issue, just remove the and tags from the generated query that U2U CAML Query Builder produces and it should all work again.

So, replace the above code with this:

SPQuery postsQuery = new SPQuery(); postsQuery.Query = string.Format(        ""+           "" +        ""+        ""+           ""+              ""+              "{0}"+           ""+        "", threadID);

SPList allPosts = SpecificForumData.GetPostList(); // Custom method to get the SPList object SPListItemCollection posts = allPosts.GetItems(postsQuery);

If all is well, you should now be able to run this query to get better performance AND return only the selected SPListItem objects from the SPList

Edit: As a result of Peter’s comment, I’d also like to mention that the RowLimit of an SPQuery object is set to 100 per default, so if you do not alter the .RowLimit property you’ll end up with a result set of maximum 100 items. Thanks Peter

Hope it helps someone :)

0 Comments 02 May 2008
Tobias Zimmergren

Tobias Zimmergren

Hi, I'm Tobias. I am a Microsoft MVP for SharePoint and I use this site to share my thoughts on tech with you on topics like SharePoint, Office 365, Azure and general web development.

  Malmö, Sweden

Related Post

Comments powered by Disqus
res.