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
Backorders
Requisition(Complete = False, RequisitionItems(BackOrder = True))
Copy
Closed Requisitions Last 30 Days
Requisition(Complete = True AND RequisitionDate >= DaysFromNow(-30, "floor"))

The floor and ceiling (ceil) values are needed to ensure the query only shows closed requisitions for the last thirty days.

  • '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
Copy
Cycle Counts Not Completed
Material(, StoreroomStock(NextAuditDate >= DaysFromNow(-1000, "floor") AND NextAuditDate <= DaysFromNow(0, "ceil")))
Copy
Cycle Counts to be Completed
Material(, StoreroomStock(NextAuditDate >= DaysFromNow(0, "floor") AND NextAuditDate <= DaysFromNow(30, "ceil") AND StoreRm = "CITY STRM"))

If you want to account for the time of day to base the query off of, replace 'floor' 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')