Ram Prasad Meenavalli
 
 

Using CAML query for SPQuery in Object Model

Published on 11-July-2012 | Comments

CAML queries are often used to query list items from a sharepoint list. There are many tools which are used to generate CAML queries which can be used in the Object Model (like webparts, controls, event receivers etc.,). Below is a sample <OrderBy> query generated from U2U CAML query builder.

<Query> <OrderBy> <FieldRef Name="Title" Ascending="FALSE"/> </OrderBy> </Query>

While using a CAML query in the object model, the most common mistake done is to assign this CAML query as it is to the SPQuery.Query property. This doesn't reutrn any results!

The tags '<Query>' and '</Query>' shouldn't be used while assigning the CAML query to SPQuery.Query property. The query works if we remove the starting and ending <Query> element. Below is a sample code which used CAML query to order items by title.

using (SPWeb spWeb = SPContext.Current.Site.AllWebs["SubSite"]) { SPList spList = spWeb.Lists.TryGetList("Employees"); SPQuery spQuery = new SPQuery(); spQuery.Query = @"<OrderBy> <FieldRef Name=""Title"" Ascending=""FALSE""/> </OrderBy>"; SPListItemCollection items = spList.GetItems(spQuery); }

WHY SHOULDN'T WE ADD <QUERY> IN THE OBJECT MODEL
The SPQuery has many properties, like Query, RowLimit, ProjectedFields etc. Internally a CAML query is prepared using all these properties which will be within a <Query> element. So, in the object model we should only specify the actualy query for the querying to work.

Author

View Ram Prasad Meenavalli's LinkedIn profile

Ram Prasad MCITP,MCTS,MCPD
SharePoint Technology Evangelist

 

 

Comments