Filters & Quick search
In Planon, searching can be done in various ways.
• Search: This box is available at the top right of the screen, and it provides quick access for searching. Note that this feature is not available in all modules.
When you use this search option, it takes priority over an existing filter. Clicking the Refresh button will display the filter results again.
• Use CTRL+space to search for an element.
• Filter and search bar
The filter and search bar is available above the elements list. You can define a search query using the search bar and then display data that is only relevant to you. The available search possibilities depend on the element you are currently working with.
You can use one specific field to search on. If required, you can also select a different search field, select an operator, and specify a value.
The following table describes the search operators in detail.
Operator | Description |
|---|---|
<, ≤, =, ≥, > <>, <> or empty | Logical operators that compare the search field with the search value. |
%searchkey% | Operator that enables you to search for entries containing (parts of) the specific word (search key). You can use multiple search keys to fine-tune your result. |
_ | The underscore can be used as a wildcard for a single character. H_t finds: Hat, Hut, Hit. |
Contains Does not contain | Operators that search for the presence of the search value in the search field. |
Contains a value Does not contain a value | Operators that search for the presence of any value in the search field. |
Starts with Does not start with Does not start with or is empty | Operators that search for the presence of the search value at the beginning of the search field. |
Ends with Does not end with Does not end with or is empty | Operators that search for the presence of the search value at the end of the search field. |
In Not in Not in or empty | Operators that search for the presence of a set of search values in the search field. |
Between | Operators that search for a range of values in the search field. It includes both the start and end values.  For orders, using the search operator Between is not possible for alphanumeric fields containing only digits because it throws off sorting. To work around this issue, do not filter on Number, but add No. (SysOrderID) to the layout to filter on the (main) order. |