RadScheduler - Query to get item for now

[David]

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

[Veselin Vasilev]

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.

[David]

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

[Gabe Silvarajoo]

I am doing something similar, where can I find the code that you wrote. Thanks.