Archive for the ‘SharePoint 2013’ Category

It would appear that, when it comes to querying calendar events in SharePoint 2013, the CAML required does not seem to recognise <Now/> as its predecessors did.

To retrieve all future events in 2007 the CAML was as follows:

2007 Events CAML
  1. var query = new SPQuery
  2.                 {
  3.                     Query = @"<Where>
  4.                                  <DateRangesOverlap>
  5.                                     <FieldRef Name='EventDate'/>
  6.                                     <FieldRef Name='EndDate'/>
  7.                                     <FieldRef Name='RecurrenceID'/>
  8.                                     <Value IncludeTimeValue='TRUE' Type='DateTime'>
  9.                                         <Now/>
  10.                                     </Value>
  11.                                  </DateRangesOverlap>
  12.                               </Where>
  13.                               <OrderBy>          
  14.                                 <FieldRef Name='EventDate' Ascending='TRUE'/>      
  15.                               </OrderBy>",
  16.                     ExpandRecurrence = true,
  17.                     RowLimit = Convert.ToUInt32(this.ItemsToDisplay)
  18.                 };

However, when trying this in 2013, only the recurring events are returned.

To fix this,  amend the query as follows:

2013 Events CAML
  1. var query = new SPQuery
  2.                         {
  3.                             Query =
  4.                               string.Format(
  5.                                  @"<Where>
  6.                                   <Or>
  7.                                      <Geq>
  8.                                         <FieldRef Name='EventDate' />
  9.                                             <Value Type='DateTime'  IncludeTimeValue='TRUE'>{0}</Value>
  10.                                     </Geq>
  11.                                       <DateRangesOverlap>
  12.                                         <FieldRef Name='EventDate'/>
  13.                                         <FieldRef Name='EndDate'/>
  14.                                         <FieldRef Name='RecurrenceID'/>
  15.                                         <Value IncludeTimeValue='TRUE' Type='DateTime'><Now/></Value>
  16.                                      </DateRangesOverlap>
  17.                                 </Or>
  18.                               </Where>
  19.                               <OrderBy>          
  20.                                 <FieldRef Name='EventDate' Ascending='TRUE'/>      
  21.                               </OrderBy>",
  22.                                          DateTime.Now.ToCamlDateFormat()),
  23.                             ExpandRecurrence = Convert.ToBoolean(context[ContextKeys.IsRecurringIncluded]),
  24.                             RowLimit = Convert.ToUInt32(context[ContextKeys.ItemsToDisplay])
  25.                         };


Firstly, I tried to use the above query using <Now/> instead of the {0} parameter of string.Format, but the non-recurring events were not returned. It turns out that you need to use a Z format date for it to work. For this, I created an extension method of DateTime as follows:

  1. /// <summary>
  2.       /// To the CAML date format.
  3.       /// </summary>
  4.       /// <param name="dateToConvert">The date to convert.</param>
  5.       /// <returns>The date in the 2012-03-21T12:18:55Z format</returns>
  6.      public static string ToCamlDateFormat(this DateTime dateToConvert)
  7.      {
  8.          return dateToConvert.ToString("u").Replace(" ", "T");
  9.      }

Hope this saves you a few hours Smile

Okay, I’ve not blogged for a while and this was mainly due to being subjected to SharePoint 2007 development once again.  However, I’m now into the land of SharePoint 2013 and I’ve no doubt I will be actively posting once more as I discover various nuances of the new environment.

So, here’s my first, which was a bit of a head scratcher!! After creating a custom list, I tried to add a new list item and received the following unhelpful error.


After a bit of Google-ing as few fixes were suggested, but none of which seemed like a viable solution. For reference, so you don’t go down same route, these were :

  • Enable Anonymous access
  • Restart the SharePoint Search Host Controller  service
  • Lack of RAM

None of these work, so don’t even try.

Next step, was to go to the logs where I found a call was being made to the /_vti_bin/client.svc/ProcessQuery

However, on opening the WCF service in the browser I received the following 500 error  “Operation is not valid due to the current state of the object” which lead me the eventual problem.

My web.config didn’t have a serviceHostingEnvironment element.  Adding the following to the <system.serviceModel> section resolved the issue

Service Hosting Element
  1. <serviceHostingEnvironment aspNetCompatibilityEnabled="true"/>

However, you may have the following already in your config

Wrong Service Hosting Environ
  2. <serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true"/>

If you remove  multipleSiteBindingsEnabled="true"  it should work

Hope this helps you save a few hours

Open-mouthed smile