How to showing the ways to filter a listbox by using the column search fields to filter.
Table of Contents
What we call ListBox are the small input fields at the top of each column. They allow you to type text in order to filter the list.
The ListBox are very useful as soon as you know what you can write in them.
Depending on the type of column, Searching won't behave the same. It is due to the fact that you won't search a Date or Time the same way you will do for a Reference or a Description.
We should distinguish three different types of Searching: the range, the strict and the extended Searching.
It's often assimilated with columns that contains only numerical value such as quantities, but it also applies to alphabetical values. Dates can be searched as numbers. In this case, we can use the Syntax that applies to Range Searching. You should also see the specific rules for Dates
Strict Searching applies for example to References. The default behavior is that the search box will take into account the exact term that you typed in. If you type "Jo", it won't find "John". It will search everything that is exactly "Jo".
Simple request and Multiple Request syntaxes apply to this kind of Searching.
Extended Searching applies for example to description field. By default, this kind of Searching will look everything that contains what you typed in.
Please notice that ListBox can be case-sensitive.
If you know exactly what you are looking for, you can just type the name in the corresponding ListBox. If you don't, or if the name is too long, you can use the "%" symbol Input
Please notice that everytime you will use a % symbol in your request, the Extended and Strict Searching will behave the same.
You can ask for Multiple request using the 'AND' 'OR' 'NOT' operators. In order for them to be used as operators, they should be written in capital. Otherwise they will be considered as the searched text:
It will Search everything that is 'John Doe' or ends with 'Roger'
With those operators, you can enter more complex queries using parentheses. If you use many different operators in the same request, without any parentheses, the operator AND will have the highest priority. Here is few examples:
If you have a column with numbers, you can filter them using the operators > < = and !=:
It also can be used with alphabetical values, considering the alphabetical order:
You can filter dates with the same operators as the ones used for numbers. Depending of the request, the interval of date that will be displayed is different: