To see an example of Filter Builder, go here: Example: Open Representation Services by Worker
The Filter Builder (FB) is an advanced search function available in any search window. It is a powerful tool allows you to refine your searches by building up search criteria.
You can start to build your search filters by right clicking on a column heading, or by selecting the blue, underlined text that displays at the bottom of your screen during a search.
The FB contains three links to different menus that enable you add to or change your search criteria. These links are displayed in Red, Blue and Green.
The Red list provides the search operators or rules.
The Blue menu is a list of fields you can search by – it matches the columns in your list view, including any not currently displayed.
The Green list contains some search criteria that you will have already seen in the column search function plus more.
The FB allows you to customise and refine searches using many different layers or combinations but not all of the search criteria fit together. For example, First Name Is between will not yield any results because Is between is best suited to dates. We could fill these pages with examples of searches that are possible using the FB but instead, we recommended that you experiment. Use the different fields and operators and see what results you get.