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

RadScheduler - Query to get item for now

3 Answers 58 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
David
Top achievements
Rank 2
David asked on 27 Mar 2009, 12:49 AM
Is there a way of firing a query that will look at the recurrence rule and return an item based on a point of time.

Basically We have an online radio schedule which we use radscheduler for, but the broadcast software needs to be able to execute a query on the hour to find out what to air next. At present we are having to maintain 2 tables, it would be great if we could just ask the radschedueler db what now.

Please help

David

3 Answers, 1 is accepted

Sort by
0
Veselin Vasilev
Telerik team
answered on 30 Mar 2009, 04:09 PM
Hello David,

The recurrence rule field in the database usually contains data in the following format:

DTSTART:20090420T110000Z 
DTEND:20090420T120000Z 
RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO 
 

You can try parsing the DTStart and DTEnd fields to get the Date and Time of the appointment.

I hope this will get you started.

Sincerely yours,
Veselin Vasilev
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.
0
David
Top achievements
Rank 2
answered on 30 Mar 2009, 05:07 PM

Thanks Veselin,
 
I think I will write a program to break the items out into individual instances for storage in a secondary table, I realise what we are doing is a little out of the ordinary.

Will publish the code after incase anyone needs it.

David

0
Gabe Silvarajoo
Top achievements
Rank 2
answered on 03 Aug 2010, 03:21 PM
I am doing something similar, where can I find the code that you wrote. Thanks.
Tags
Scheduler
Asked by
David
Top achievements
Rank 2
Answers by
Veselin Vasilev
Telerik team
David
Top achievements
Rank 2
Gabe Silvarajoo
Top achievements
Rank 2
Share this question
or