TcxCustomSchedulerStorage.CalculateEventActualTimeRanges Method

Populates the ActualStart and ActualFinish fields with the values of the user event‘s time period bounds.

Declaration

procedure CalculateEventActualTimeRanges;

Remarks

There may be user events persisted in a data store, which were scheduled prior to the TcxSchedulerEvent.ActualStart and TcxSchedulerEvent.ActualFinish properties were introduced in ExpressScheduler 2.

The purpose of using the above properties is to improve performance when querying the data in the data store. This is achieved by using a time range condition (specified by these properties) to select user events.

Along with other information on the scheduled user event, time period bounds are persisted in a data store (see the TcxSchedulerDBStorageFieldNames.ActualStart and TcxSchedulerDBStorageFieldNames.ActualFinish properties) since ExpressScheduler 2 was released.

After the table containing legacy user events was restructured, the ActualStart and ActualFinish fields store null values for those user events. As a result, if the time range is applied (if the UseActualTimeRange property is set to True to indicate the scheduler to use the time range), these user events won’t appear in the scheduling area.

To avoid this use the CalculateEventActualTimeRanges method to populate the ActualStart and ActualFinish fields with appropriate values.