Recurring Activities

BTW - We need to do this using the Javascript version of the DayPilot.

Thanks

The JavaScript version doesn’t have built-in support for recurring events.

You need to implement this feature on the server side and pass the full list of occurrences to the component on the client side.

In general, for example for MVC, do you store each and every event in the database or just extrapolate uisng the interval and period.

For example if the start date is 2026-01-01 and interval is 1 and period is weekly then we just show an event every week without actually storing each event in the database.

But this would break if a single occurance is deleted or changed for wahrever reason.

If one does actually store the actual events in the database, the events can go on forever, how many does one need to store initially?

Sorry we are confused, but with your experience we thought you may be able to point us in the right direction.

Thanks.

The MVC and ASP.NET versions use a server-side implementation that works like this:

1. It stores the master event in the database, along with the recurrence rule.

2. Every exception from the rule (a single occurrence is deleted or modified) is stored as a separate record. It is identified using the original occurrence start date.

3. There is an Expand() method that takes the source dataset, scans it for rules and exceptions and generates individual occurrences.

This aproach has a few drawbacks:

1. When loading event data for a certain date range, you always need to load ALL master events from the past.

2. It’s not possible to query occurrences (e.g., when searching for text) in the database because they aren’t stored there.

This might work in some cases, but usually it will be necessary to maintain a cache table with all occurences pre-generated.

The recurrence implementation can get very complex. I recommend evaluating the requirements carefully because unlimited support may complicate your life a lot.

Thanks for the advice.

Just one more question.
In your implementation, is every occurance actually stored in the Database or just the exceptions.

Thanks

Just the exceptions.