Searching for recurring events

2 posts, 0 answers
  1. Andy Green
    Andy Green avatar
    376 posts
    Member since:
    Aug 2008

    Posted 25 Nov 2014 Link to this post


    This isn't specifically for the Telerik guys, rather the community. Does anyone have any ideas how I would query the database to find either recurring events, or rooms that don't have events, when taking into consideration recurring events?

  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    2062 posts

    Posted 28 Nov 2014 Link to this post

    Hello Andy,

    First I would like to explain something about the recurring appointments. In the data base are stored only the master appointments and they have set recurrence rule (RecurrenceRule property). Based on that recurrence rule value the occurring appointments are generated on the fly. Please note that exception appointments are also stored to the data base as separate records and they have reference to the master appointment using the RecurrenceParentID property.

    In other words the master appointment (stored in the data base) contains information about the recurring appointments resource ( Room for example).

    For example you can look for a specific RoomID and query the appointment records with non empty recurrence rule field ( to find regular recurring appointments) and RecurrenceParentID ( this is optional  and it is valid only if you have exception appointments). If the returned result set is 0 the room does not have any recurring events.

    Boyan Dimitrov

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

Back to Top