Skip to main content

Print Job Viewer Filter Syntax

Pro & Enterprise Only

This feature is available exclusively in ScrewDrivers Pro and Enterprise editions.

The Print Job Viewer provides a filter field that allows you to selectively display print job records from the database. The filter uses standard SQL WHERE clause syntax, enabling powerful queries across print job metadata including user names, printer names, timestamps, document names, and job numbers.

Syntax Construction​

For a basic sort based on a column's value treating the value as a string, use the "=" operator and enclose the value in single quotes:

[Column Name] = 'Value'

For a basic sort based on a column's value treating the value as a numeric type use the =, <, >, <=, >= operators:

[Column Name] > Value

Note that this comparison can be performed with timestamps as well by enclosing the timestamp value in the "#" sign:

[Column Name] > #7/1/2016# AND [Column Name] <= #7/6/2016 8:00:00 AM#

You may concatenate any of the above expressions using Boolean AND, OR, and NOT operators, and may use parentheses to force precedence:

([Last Name] = 'Smith' OR [Last Name] = 'Jones') AND [First Name] = 'John'

You may use wildcards in string searches by replacing any number of characters with the "%" operator and using the "LIKE" keyword:

[Column Name] LIKE '%value%'

This would match any string that contained the sequence of characters "value", with any number of characters before or after. The wildcards may be placed anywhere in the field.

Column Names​

The following column names are possible:

  • Document Name
  • User Name
  • Originating Server
  • Job Number
  • Printer Name
  • Print Server
  • Start Time
  • End Time

Common Use Cases​

The following examples demonstrate typical filtering scenarios for print job analysis and reporting.

Report all jobs for a given printer and time range​

To display only print jobs sent to a specific printer within a time window, combine printer name and timestamp filters. This example shows jobs sent to Printer 1 between 9:00 AM and 9:05 AM on July 5, 2016:

[Printer Name] = 'Printer 1' AND [Start Time] >= #7/5/2016 9:00:00 AM# AND [End Time] <= #7/5/2016 9:05:00 AM#

Report all jobs for a given user​

To track printing activity for a specific user, filter by username and time range. This example displays all print jobs from user mmouse during the week of July 3-9, 2016:

[User Name] = 'mmouse' AND [Start Time] >= #7/3/2016 12:00:00 AM# AND [End Time] <= #7/9/2016 11:59:59 PM#

Report all print jobs for a specific day​

To view all printing activity for a given day across all printers and users, filter by start and end timestamps. This example shows all jobs that both started and finished on July 8, 2016:

[Start Time] >= #7/8/2016 12:00:00 AM# AND [End Time] <= #7/8/2016 11:59:59 PM#
  • Reference: Reports Reference - Comprehensive print job reporting and analysis with pre-built report templates and custom report creation