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.
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:
For a basic sort based on a column’s value treating the value as a numeric type use the “=”, “<”, “>”, “<=”, “>=” operators:
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.
The following column names are possible:
- Document Name
- User Name
- Originating Server
- Job Number
- Printer Name
- Print Server
- Start Time
- End Time
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.
[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.
[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.
[Start Time] >= #7/8/2016 12:00:00 AM# AND [End Time] <= #7/8/2016 11:59:59 PM#