Open topic with navigation

Creating Custom Filters

By creating custom filters, you can search through the entire database for specific content and then quickly retrieve and display the results in Reprint Console. You can create a custom filter for displaying specific data by clicking Custom in the filter controls or by opening the Custom AutoFilter dialog.

A custom filter is an SQL query that is applied against the data in the database. Reprint Console displays all data that matches the conditions that are specified in the query. Data that does not match the conditions is ignored. A simple filter consists of three parts: a database field to search, an assignment operator, and a filter value. When you run a filter, Reprint Console performs the following procedure:

  1. Retrieves the values from the specified database fields.

  2. Compares the values to the filter value, based on the assignment operator.

  3. Displays records that fit the filter criteria.

To filter for more information, you can define additional filter clauses by adding a second condition that is separated by a Boolean operator. A Boolean operator defines how multiple filter statements apply to each other.

Using Custom Filter Controls

You can create custom filters by using the filter controls in the active pane. When you click Custom in the View list, you can configure options to customize your filter, as described in the following table.

Option

Example

Description

Boolean operator

And
Or
Not And
Not Or

Defines how multiple filter condition statements are linked together.

Action

Specifies an action to take, such as inserting a new condition, creating a new group of conditions, or deleting all existing conditions and groups.

Add condition

Adds a new condition to the group.

Available fields

Computer
Copies
Job Name

Displays a list of available fields to search.

Assignment operators

Begins with
Equals
Is between

Specifies the criteria that the value must meet to be included in the filter results.

Filter values

<enter a value>

Specifies the values that the filter searches for when you run it.

Field comparison

Compares the contents of two or more fields, rather than comparing a field value to a user-defined filter value.

Add additional value

Inserts an additional value to a list of values. Available only when the Is any of or Is none of assignment operator is selected.

Delete condition

Removes a condition from a group.

Example: Creating a Custom Filter

The following example filters the BarTender System Database for all print jobs that were or might have been successfully printed. In other words, all print jobs that were cancelled or that resulted in a printer error do not appear when the filter is run.

To create this filter, check the "Last Status" database field for the values "Cancelled" or "Error." If either of these values are found, then the corresponding database entry is hidden from view. All other entries appear in the filtered results.

ClosedTo create a custom filter

  1. In the View Selector pane, click Custom under the BarTender: Print Jobs view header.

  2. In the Filter area of the BarTender: Print Jobs pane, click Custom in the View list.

  3. Click to add a condition.

  4. Click the Available fields value (by default, this is set to [Computer]), and then click Last Status.

  5. Click the Assignment operator value (by default, this is set to Equals), and then click Is none of.

  6. Click the <enter a value> field to activate the text input field.

  7. In the list, click Cancelled.

  8. Next to the newly added Cancelled value, click to add another value.

  9. Click the <enter a value> field to activate the second text input field.

  10. In the list, click Error.

  11. Click Apply Filter to run the filter and return all matching database records.

Related Topics