SchedulerItemBase.QueryEnd Property

Gets the normalized appointment end value which is recommended for use in interval-based appointment data source queries.

Namespace: DevExpress.Xpf.Scheduling

Assembly: DevExpress.Xpf.Scheduling.v19.2.dll

Declaration

C#

public DateTime QueryEnd { get; }

VB.NET

Public ReadOnly Property QueryEnd As Date

Property Value

Type	Description
DateTime	A DateTime value that is the end of the appointment.

Remarks

The SchedulerItemBase.QueryStart and QueryEnd properties allow you to calculate the correct interval for use in a SELECT query when handling the SchedulerControl.VisibleIntervalsChanged event to fetch appointments from the data source. The use of the SchedulerItemBase.Start and SchedulerItemBase.End properties is not recommended in this situation, because you can miss the appointment pattern and lose appointment exceptions.

The Interval property returns the normalized duration based on the QueryStart and QueryEnd values.

The QueryEnd property return values are dependent on the appointment type, as shown in the following table.

Appointment Type	QueryEnd Value
AppointmentType.Normal	The SchedulerItemBase.End value.
AppointmentType.Pattern	The End value of the last appointment in the recurring series. If the series is infinite (no end date), the DateTime.MaxValue is returned.
AppointmentType.ChangedOccurrence	The End value of an original occurrence before modification (as if an occurrence is restored from the exception).
AppointmentType.DeletedOccurrence	The End value of an original occurrence before modification (as if an occurrence is restored from the exception).

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the QueryEnd property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

scheduler-crud-events/CS/Behaviors/SchedulerControlEditingBehavior.cs#L49

    return true;
if (rec.Range == RecurrenceRange.OccurrenceCount && editAppt.QueryEnd <= DateTime.Now)
    return true;

VB.NET

scheduler-crud-events/VB/Behaviors/SchedulerControlEditingBehavior.vb#L59

End If
If rec.Range = RecurrenceRange.OccurrenceCount AndAlso editAppt.QueryEnd <= DateTime.Now Then
    Return True