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
1 Answer, 1 is accepted
0
Boyan Dimitrov
Telerik team
answered on 28 Nov 2014, 09:36 AM
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
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.