Mikko Mertanen
Top achievements
Rank 1
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
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
0
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.
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
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
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
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.