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 +1000 > From: [EMAIL PROTECTED] > To: listserver@ozmoss.com > Subject: 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