Parsing RRULEs within SQL for recurring events

5 posts, 0 answers
  1. Joel
    Joel avatar
    3 posts
    Member since:
    Feb 2009

    Posted 06 Jan Link to this post

    I am using the Scheduler for scheduling upcoming events, some of which could be recurring. I understand that the standard RRULE format is used to denote recurrences, and that 3rd party libraries, like DDay.ical, can be used to expand those events once they're pulled down from the database. However, in the interest of efficiency, I would prefer to be able to return recurring events for a given date range via a SQL query.

    The reason for this is that a web API service will be used to return these recurring events, so there should be no reliance on the Scheduler calendar when being consumed by this service. I want to avoid having to retrieve all recurring events, then looping through them, parsing/expanding one-by-one in order to throw out the ones that do not apply.

    All said, does anyone have a good method for querying these events, based on their RRULE definitions, within the database? I imagine something like this is going on within the Scheduler components, but I'm not completely sure.

    Thanks!

  2. Joel
    Joel avatar
    3 posts
    Member since:
    Feb 2009

    Posted 06 Jan Link to this post

    One possibility I've considered is to create records associated with the event in a separate database table on event save. Doesn't seem ideal, but may be the best way to approach this. Thoughts?
  3. Kendo UI is VS 2017 Ready
  4. Vladimir Iliev
    Admin
    Vladimir Iliev avatar
    2172 posts

    Posted 11 Jan Link to this post

    Hi Joel,

    Currently there is no such build-in way of expanding the recurring events on the SQL server and custom solution would be required. Custom solutions however falls outside the scope of this support service as it hovers the build-in functionality of the controls only. 

    Regards,
    Vladimir Iliev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  5. Joel
    Joel avatar
    3 posts
    Member since:
    Feb 2009

    Posted 11 Jan in reply to Vladimir Iliev Link to this post

    Thanks, Vladimir. However, I figure Telerik is doing this parsing behind the scenes. It would be handy if that parsing became available for the general public :)
  6. Vladimir Iliev
    Admin
    Vladimir Iliev avatar
    2172 posts

    Posted 12 Jan Link to this post

    Hello Joel,

    Thank you for your feedback. Also please note that as starting point you can check the following blog post for the RadScheduler, which use the same recurrence rule standard (RFC 5545):

    Regards,
    Vladimir Iliev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready