View All Notifications C Corner Post An Article A Blog A News A Video An EBook An Interview Question Ask Question TECHNOLOGIES ANSWERS LEARN NEWS BLOGS VIDEOS INTERVIEW PREP BOOKS EVENTS CAREER MEMBERS JOBS Working with SPQuery and CAML Shyju Updated date Jan 02, 2011 76.6 k 0 0 Working with SPQuery and CAML -- facebook twitter linkedIn Reddit WhatsApp Email Bookmark expand As a sharepoint developer most of the people might have used SPQuery and CAML atleast once.

Writing a Basic Query SPContext ctx SPContext.Current; using (SPSite site new SPSite(ctx.Site.ID)) using (SPWeb web site.OpenWeb(webid)) SPList list web.ListsMyTestList; SPQuery query new SPQuery(); You have to call GetItems function of SPlist to execute the CAML query SPListItemCollection items list.GetItems(query); Here it will return All the Items.But in real time we need to specify the conditions and attributes to fine tune the Results.

Sql To Caml Query Converter Mp3 Full Advantage Of

We need to have basic understanding of CAML syntax inorder to take full advantage of SPQuery Object.If you have a CAMLBuilder tool then it will be always handy in writing CAML queries.You could douwnload CAML builder from here Understanding SPQuery Properties 1.

SPQuery.RowLimit This Property allows you to set how many rows you need in your result.Its quiet common that your Query could return more than 500 rows so its better to limit the number of rows in a result and use paging to retrive the rest of the result.I will explain paging below.

ViewAttributes View attribute is one of the important attribute which is veryusefull to set how you are going to retrieve the Data.

Scenario 1: You want retrieve all the items including items in folder and subfolders then set it like the following If you want to return only file SPQuery.ViewAttributes ScopeRecursive; If you want to return All items SPQuery.ViewAttributes ScopeRecursiveAll; Scenerio 2: You want retrive only files spquery.ViewAttributes ScopeFilesOnly; Scenario 3: Only Approved Items spquery.ViewAttributes ModerationTypeHideUnapproved 3.

SPQuery.Folder This property is usefull when you want to retrieve the data only from specific folder.In real world scenario you need to retrive the items from specific folder rather than retrieving all items in the list.

SPQuery.Folder folder; It should be a SPFolder Object 4.SPQ uery.ViewFields This property helps to set which are the fields columns you want in the result.There is no point in returning all the coloumns.So its better practice to specify the fields you want to return.

Name is the coloumn name internal name of the field SPQuery.ViewFields; 5.

SPQuery.Query This property used to set the real CAML query.Build your CAML string and assign to this property.

SPQuery.Query String.Format(lt;Wheregt; lt;Eqgt; lt;FieldRef NameFileLeafRefgt; lt;Value TypeTextgt;lt;Valuegt; lt;Eqgt; lt;Wheregt;, searchText); searchText is name of the file you want to search Note: One thing here we have to remember is no need to add query tag in your XML.

If you are using Date time in your query then set includetimevalue true.

Sql To Caml Query Converter Mp3 Code That Will

See Below Query lt;Wheregt;lt;Eqgt;lt;FieldRef NameModifiedgt;lt;Value TypeDateTime IncludeTimeValueTRUE gt; LastCheckedDate lt;Valuegt;lt;Eqgt; lt;Wheregt; CAML Notations Eq equal to Neq not equal to BeginsWith begins with Contains contains Lt less than Leq less than or equal to Gt greater than Geq greater than or equal to IsNull is null IsNotNull is not null Paging In SPQuery Using paging with SPQuery is good practice.Its better to write code that will perform efficient way than giving bad user experience.

All contents are copyright of their authors.