Skip to main content

Retrieve recent 7 days items from SharePoint list using CAML Query

This is an interesting stuff even though it is very simple. Assume we have to retrieve  recent 7 days items from a sharepoint list. For this purpose obviously we need to use CAML query (static query, not dynamic) . You can use the following code snippet for the reference.

 Assume you have got SPSite object and continue with the following snippet.


SPList list = site.RootWeb.Lists["PradeepaStats"];

 SPQuery query = new SPQuery();

 query.Query = "<Where><Eq><FieldRef Name='TaskDueDate' /><Value IncludeTimeValue='TRUE' Type='DateTime'>[Today-7Day(s)]</Value></Eq></Where>";

 SPListItemCollection items = list.GetItems(query);


Hope this  may help someone


Cheers
Pradeepa achar



Comments

Unknown said…
dude.. Start sharing your articles on http://citihunters.co.in/
March 25, 2014 at 12:44 PM
Post a Comment

Popular posts from this blog

How to get the SharePoint central admin url programmaticaly via C#?

I had come across a situation where i had to get the sharepoint central admin's url.. You can follow the following snippet of the code. At the begining add the namespace  using Microsoft.SharePoint.Administration; SPAdministrationWebApplication centralAdminFarmUrl =  Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local ; String  centralAdminUrl = centralAdminFarmUrl.Sites[0].Url;  This may help someone -Cheers Pradeepa Achar
1 comment
Continue »

Programmatically read the value from web.config file

Here is a situation where you need to keep a key value pair element in the web.config file and read them during the run time. I suggest, better keep key /value pair under <appSettings> element and read it programmatically . <appSettings>   <add key=" LicenseKey " value=" 987jKouterhsk " /> </appSettings> Assume , you have added a license key as above in the web.config file. You need the license key during run time. You can access the license key class named "ConfigurationManager". write a property  called getLicenseKey and return the corresponding license key. public string GetLicenseKey {    get{   return  ConfigurationManager.AppSettings[" LicenseKey "]; } } Now the property GetLicenseKey will have the value 987jKouterhsk. Use this value as per your requirement. -Cheers Pradeepa Achar
Post a Comment
Continue »