Print Job Viewer Filter Syntax

Owned by Andrew Parlette
Dec 08, 2016
2 min read

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:



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

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

Report all jobs for a given user

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

Example

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