RadScheduler - Query to get item for now

4 posts, 0 answers
  1. David
    David avatar
    10 posts
    Member since:
    Apr 2008

    Posted 26 Mar 2009 Link to this post

    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

  2. Veselin Vasilev
    Veselin Vasilev avatar
    2992 posts

    Posted 30 Mar 2009 Link to this post

    Hello David,

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


    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.
  3. David
    David avatar
    10 posts
    Member since:
    Apr 2008

    Posted 30 Mar 2009 Link to this post

    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.


  4. Gabe Silvarajoo
    Gabe Silvarajoo avatar
    13 posts
    Member since:
    Apr 2009

    Posted 03 Aug 2010 Link to this post

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