Searching for recurring events

[Andy Green]

Hi

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?

Andy
​

[Boyan Dimitrov]

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.


Regards,
Boyan Dimitrov
Telerik