blog.richardramdat.com

SharePoint CAML Query Date

 January 26th, 2010 › Development, SharePoint › richard ›

For the past two SharePoint implementations that I’ve worked with, it was a common business requirement to query from a list to retrieve items that should be displayed on a “scheduled” basis. Think along the lines of an alert or announcement. Typically what I end doing is create a custom list and add the following three fields, “StartTime”, “EndTime” and “Active”. Start and End Time are the fields for scheduling the list item. I make them a Date+Time field and also allow them to be optionally be null, this way someone can create an open ended item that starts at a specific time but has no specified End Time. The Active field is a simple yes/no that is a convenient kill-switch or safety check.

So with the three columns, the following CAML query can be used to query items that should be currently displayed:

<Where> <And> <And> <Or> <Leq> <FieldRef Name='StartTime' /> <Value Type='DateTime' IncludeTimeValue='True'> <Today /> </Value> </Leq> <IsNull> <FieldRef Name='StartTime' /> </IsNull> </Or> <Or> <Gt> <FieldRef Name='EndTime' /> <Value Type='DateTime' IncludeTimeValue='True'> <Today /> </Value> </Gt> <IsNull> <FieldRef Name='EndTime' /> </IsNull> </Or> </And> <Eq> <FieldRef Name='Active' /> <Value Type='Boolean'>1</Value> </Eq> </And> </Where> <OrderBy> <FieldRef Name='Modified' Ascending='False' /> </OrderBy>

1 Comment

Comments RSS   TrackBack Identifier URI

Leave a comment

Name (required)

Mail (will not be published) (required)

Website

Your comment