How to: Filter Appointments

• Dec 17, 2020

The following example demonstrates how to filter appointments displayed within a scheduler according to a condition. The ASPxSchedulerDataWebControlBase.FilterAppointment event is intended specifically for this purpose. The code below demonstrates how to hide all tentative appointments (those whose status is set to AppointmentStatusType.Tentative).

C#

using DevExpress.XtraScheduler;
using DevExpress.Web.ASPxScheduler;
// ...

protected void ASPxScheduler1_FilterAppointment(object sender, PersistentObjectCancelEventArgs e) {
    // Filter all tentative appointments.
    int statusID =  ASPxScheduler1.Storage.Appointments.Statuses.GetStandardStatusId(
        AppointmentStatusType.Tentative);

    e.Cancel = ((Appointment)e.Object).StatusId == statusID;
}

VB.NET

Imports DevExpress.XtraScheduler
Imports DevExpress.Web.ASPxScheduler
' ...

Protected Sub ASPxScheduler1_FilterAppointment(ByVal sender As Object, ByVal e As _
PersistentObjectCancelEventArgs) Handles ASPxScheduler1.FilterAppointment

    ' Filter all tentative appointments.
    Dim statusID As Integer = ASPxScheduler1.Storage.Appointments.Statuses. _
        GetStandardStatusId(AppointmentStatusType.Tentative)
    e.Cancel = (CType(e.Object, Appointment)).StatusId = statusID

End Sub