Simple filter
Use for simple searches.
Usually has focus at first.
You can use wildcards. (see Wildcards section below)
You only need to type first few letters.
You can use the Search and named filter dropdowns to narrow the results.
If you do not see the results you expect, look at the Search dropdown to check that the filter is applied to the correct column.
Advanced filter
When you select the Advanced Filter, it appears in a popup frame, as shown below.
Use for filtering more than one field.
Provides more filtering options such as ranges and from/to.
Can use full values or wildcards for Matches field.
Filter buttons
Name | Description |
Apply Filter | Applies the filter on a search. Shortcut: Ctrl+Shift+A |
Simple / Advanced Filter | Swaps between the simple filter and the advanced filter for more specific searches or to search for a range of values. |
Toggle Filter | Shows or hides the filter frame (if advanced filter is active). Shortcut: Ctrl+Shift+F |
Save Filter | Lets you save the current filter settings. You can recall them later using the drop-down selector. |
Browse Menu (at the top left of a browse screen) | Displays a menu that allows you (among other things) to show only the records you have selected. This is useful if you have selected several separate records on different screens. You can also use this to select all the records that are shown by the current filter setting: hold down Shift and click  . |
Wildcards (used with filters)
Character | Definition | Example | Result |
* | Any string of characters
| b* | Show any item beginning with b that has any number of characters after it |
*builder* | Show any item with builder and any number of characters before or after it |
|
|
|
| *b | Show any item ending with b, but with any number of characters before it |
. | Single character | b.b | Show any item beginning and ending with b, with a single character in the middle |
! | Exclude | !brick,* | Show everything except the item brick (excludes must come first - *,!brick would include everything, including brick) |
,, (commas) | List | brick,tile | Show only the items brick and tile |