The Extended Filter can be used to create more complex filters for your list. It allows more filter operators and conditions than the simple filter. You can use parenthesis to group columns in several steps or layers, and enter conditions.
By default the operator "Greater than, equal to" (>=) is used in the first row. If the same column is included in the next row, the default operator will be "Less than, equal to" (<=) on that row. The default condition between two rows is "AND". So far, the principle used is the same as for the simple filter. But in the extended filter, you can modify this principle.
If you filter a list you can save and load filter profiles to re-use it at a later date. This can also be done via the menu Edit | Filter profiles… in the list. However, filter profiles are not available in tables in the registration procedures.
The Extended Filter window.
Encapsulate Expression
You can encapsulate expressions on the rows in the window if you want to use classification or nestling of filters. In the two columns "(" and ")" you can enter up to four parentheses per row to create classified or nested filters at several levels. This way you can for example enter several rows and group them as an expression for the condition "AND" and "OR". Please remember that there must be as many right as left parentheses in the entire filter.
Left parenthesis.
Right parenthesis.
Column
Here you choose which column in the list that should be filtered.
Operator Type
There are seven different operators to choose from, as well as an alternative for filtering the text.
Operators.
Value
Here you enter the value that is the limit. When filtering text, you should enter the text string that should be filtered. You can filter text by using the wildcards "%" and "_".
AND/OR
This is where you choose your Boolean condition for the row or all the rows (if you are using parentheses). The default condition for a new row is "And". You can choose between "And" and "Or".
Boolean conditions.
The Add and Delete Buttons
The Add button adds a new row at the top of the window. The Delete button deletes the current row. You can add a new row at the end by using either the regular Tab or Enter keys in the condition column.
The Save... and Load... Buttons
You can save a filter as a filter profile by using the Save… button. By using the Load… button you can load such a filter profile. This is useful if you want to reuse the filter. Read more about this function under Filter Profiles in Lists.
The Purge Filter Button
The Purge filter button will remove all rows in the window.
The Simple Filter Button
The Simple filter... button will switch over to the simple filter window. This button will be greyed out if you are using any operator type other than ">=" or "<=", if a parenthesis is used, or the condition "OR" is entered in any of the rows. This indicates that you are using an operator type or expression that is not supported by the simple filter. Then you cannot switch to that window.
The Advanced Button
By using the Advanced button, you can create an advanced filter of your list. In that window a filter is created by entering functions with the desired values, operators and other selectable tables in the database. By using the button called Verify a check is made to make sure that the filter is OK.
The Specify Filter window where you create the advanced filters.
To be able to create an advanced filter for a list, you must be familiar with SQL and understand the importance of table names in MONITOR's database. If you need to create an advanced filter and are unsure of how to do it, please contact an instructor/consultant at Monitor ERP System AB for instructions.
The Test Filter Button
Here you can test a filter that you have created to make sure that there are no syntax errors. If the filter is correct, a message window will appear where it says "Filter OK!". Otherwise it will say "Incorrect filter".