Show only certain records in a View

Open a Data View window from the main window's tree view, e.g. Jobs-Summary. Right click on the view and select Filter. The Filter window will be shown:

The window has a drop-down list box - the contents of which vary depending on which type of data you are filtering. The above example shows the filters available on Job related windows.

However, there are two filters that are common to all windows.

• "No current filter" means that all records are shown.
• "Custom filter" we will come back to this later

Selecting one of the other filters will normally result in another box appearing where you enter the value to search for, e.g.:

Some filters might require you to enter two search values, e.g.:

Using AND OR and brackets for more complex filters
On those filters that require you to enter a search text, you can enter multiple words and phrases, using AND, OR and brackets to specify more complex conditions. The following examples assume you are setting a filter on the Job Problem:

Custom Filters
This is only for advanced users, you will need to understand Structured Query Language (SQL). If you select this from the drop-down list, the window will change:

The box at the bottom allows you to enter a custom WHERE clause for the data view. The Columns drop-down list shows all the columns involved in the SELECT clause for this data view.

Home