This is a migrated thread and some comments may be shown as answers.

Fetching recurring appointment occurrences using SQL

3 Answers 100 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Mikko Mertanen
Top achievements
Rank 1
Mikko Mertanen asked on 31 May 2010, 08:24 AM
Hi!

We need functionality to fetch the actual occurrences of a recurring appointment using select statement in SQL. Parsing those recurrence rules with SQL is not very straighforward. I found this ExpandRecurrence_UDF managed database function solution from http://www.telerik.com/community/forums/aspnet-ajax/scheduler/sql-reporting-display-all-recurring-appointments.aspx.
Is this offcially supported way of doing the thing and is it safe to start using it? It actually does exactly the thing we need.

Thanks in advance

Mikko

3 Answers, 1 is accepted

Sort by
0
T. Tsonev
Telerik team
answered on 31 May 2010, 10:39 AM
Hello Mikko,

The solution provided in the blog post is what we recommend for this scenario. It's provided "as is", but we'll be glad to help if you have any issues implementing it.

I'm not sure how you define safe, but the code is fairly trivial and you're free to inspect it. The SQL server itself poses serious restrictions on what managed UDFs can do as well.

All the best,
Tsvetomir Tsonev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Mikko Mertanen
Top achievements
Rank 1
answered on 31 May 2010, 11:40 AM
Hello!

The functionality we need is in there and it's working perfectly for our needs. My main concern is that if there are going to be any changes in recurrence rule handling in scheduler, the udf implementation would not work any more. I guess the recurrence rule syntax is standard and there will be no changes. If that would actually happen would you provide new version of the udf-files?

Mikko
0
Peter
Telerik team
answered on 02 Jun 2010, 05:25 PM

Yes, as mentioned in this blog post, the recurrence rule follows a strict standard and you can rest assured that we will not change it.


Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Scheduler
Asked by
Mikko Mertanen
Top achievements
Rank 1
Answers by
T. Tsonev
Telerik team
Mikko Mertanen
Top achievements
Rank 1
Peter
Telerik team
Share this question
or