Missed Appointments

Follow

Summary

Using advanced searches, you can easily create a search view which allows you to keep track of any jobs on which you have missed appointments.

Once you have created your view, you can save it following the instructions here.

Examples

Jobs With Missed Appointments

The following OQL query can return any jobs which have pending appointments on them whose planned start date has passed

jobStatus IN ('Work in Progress','Waiting to Start') AND job IN jobsWithAppointments('PENDING',"all") AND pendingAppointmentStartDate <= now()

img1.png

Missed Appointments from Yesterday

The following OQL can return all jobs which had a pending appointment yesterday which was not started by its planned start date.

The dtoff function in this example uses a value of -1d (denoting one day in the past), but this can be changed to fit your needs

job IN jobsWithAppointments (all,all) AND Pendingappointmentstartdate<=dtoff(-1d) AND Pendingappointmentstartdate>=dtoff(-1d)

img2.png