Are you trying to roll-up all the information, or just query it for external reasons? Bamboo makes a Calendar Roll-up that will iterate all calendars and display the information, and there are others... http://www.ideseg.com/SharepointCsegRollUpAggregateInCalendarView.aspx http://www.kwizcom.com/ProductPage.asp?ProductID=175&ProductSubNodeID=176 http://www.endusersharepoint.com/?p=15 http://store.bamboosolutions.com/pc-31-1-calendar-plus-web-part-release-12.aspx
Date: Mon, 6 Oct 2008 12:47:44 +1000From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Re: [OzMOSS] SPSiteDataQuery and Calendar recurrence The Problem with this approach is I need to query across the entire site collection based on contenttype. Accessing each Calendar individually and querying the data would not be very efficient. That is why I would have liked to use SPSiteDataQuery. I am very, very aware of all the reasons for not accessing the database directly, but without an alternative solution, I don't seem to have any other choice. Do people agree that querying every Calendar individually would be very inefficient? There could potentially be 50-100 Calendars throughout the enterpise. On Mon, Oct 6, 2008 at 10:50 AM, Dave Porter <[EMAIL PROTECTED]> wrote: Is this a Pilot or POC? If it is a Production system, do not go the Direct Database Route, it is not supported and if you mess up something...then well...there you go. I wouldn't advise it. Try these to see if they help... http://sridharu.blogspot.com/2008/01/how-to-read-recurring-events-using-caml.html http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfieldrecurrence.aspx Dave P Date: Mon, 6 Oct 2008 10:21:03 +1000From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Re: [OzMOSS] SPSiteDataQuery and Calendar recurrence As bad as it is, perhaps the most efficient way is going to be directly accessing the Database. I know it is never a good idea to do so... but we are left with very little choice on this one. Any more thoughts? On Fri, Oct 3, 2008 at 8:57 PM, Bill Williamson <[EMAIL PROTECTED]> wrote: Recurrance is nasty. I'm not aware of any way of getting it except for hardcoding some logic, which might change later.If there is a helper class for this someone please chime in, I will be grateful! On Wed, Oct 1, 2008 at 1:45 PM, Sharepoint Consultant <[EMAIL PROTECTED]> wrote: Hi all, I need to search for all Calendar events across my site collection. I need for the query to return all recurrence information so that I can replicate events to a separate system. Can I do this with SPSiteDataQuery or is SPList.GetItems(SPQuery) the only way of achieving this? Obviously looping through all Lists is not a very neat solution. Thanks heaps.------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com