Query Examples

Here are some example queries that can be used within the advanced Query on the Query Editor page. See Add a Query for more information.

Copy
Work Order is Past Due
WorkOrder(DateCancelled = NULL AND ActualFinishDate = NULL AND ProjectedFinishDate != NULL AND ProjectedFinishDate < DaysFromNow(0,'keep'))
Copy
Work Order is not Past Due
WorkOrder(DateCancelled = NULL AND ActualFinishDate = NULL AND ProjectedFinishDate != NULL AND ProjectedFinishDate >= DaysFromNow(0,'keep'))

If you want to account for the time of day to base the query off of, replace 'keep' with any of the following suggestions:

  • 'keep' means the date and time it currently is
  • 'floor' means from the beginning of the day
  • 'ceil' means from the end of the day

EXAMPLE

Start of the day

  • DaysFromNow(0, 'floor')
Copy
Previous Three Months
WorkOrder(Description = "Abandon Main" AND ProjectedStartDate >= MonthsFromNow(-3, "floor") AND ProjectedStartDate <= MonthsFromNow(0, "ceil"))

The floor and ceiling (ceil) values are needed to ensure the query only shows work orders for the last or previous three months. The description of "Abandon Main" is just an example. You will need to enter your own description for your query.

Copy

Next Three Months

WorkOrder(Description = "Abandon Main" AND ProjectedStartDate >= MonthsFromNow(0, "floor") AND ProjectedStartDate <= MonthsFromNow(3, "ceil"))

The floor and ceiling (ceil) values are needed to ensure the query only shows work orders for the next three months. The description of "Abandon Main" is just an example. You will need to enter your own description for your query.