Print Job Viewer Filter Syntax

The Print Job Viewer contains a filter field to selectively display results from the database. The syntax used is SQL syntax that would normally be used in the WHERE clause.

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

Examples

Report all jobs for a given printer and time range

The following example will display only print jobs sent to Printer 1 between 9:00 AM and 9:05 AM on July 5, 2016.

Example
[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

The following example will display only print jobs from user mmouse in the past week.

Example
[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 to any printer yesterday

The following example will display only all print jobs that started and finished yesterday for all printers.

Example
[Start Time] >= #7/8/2016 12:00:00 AM# AND [End Time] <= #7/8/2016 11:59:59 PM#