Filtering Data

Use the History Explorer filter functionality to quickly create simple or complex filters that search the entire BarTender System Database for specific data. When you specify and run a filter, History Explorer displays only the records that meet the specified criteria.

A filter is similar to an SQL query. It defines database fields to search through and values to search for, and it links multiple search strings together by using Boolean operators (such as AND, OR, and NOT AND). Use the History Explorer filter tool to select the Boolean operators and available database fields that you want, and then enter the values that you want to filter by.

By using the filter controls, you can create filters that can search for a single entry in a specific record field, search for multiple entries in one or more fields, search for records that do not contain specific data, or compare entries in multiple fields and then display only the records that match the comparison.

In This Section