Filter Manager

Top  Previous  Next

The Filter Manager is a visual SQL query editor. The Filter Manager helps you to build complex SQL statements with a very simple graphical user interface.

 

If no filter is specified, the Filter Manager looks like this:

 

filterman1

 

Choose a filer from the list or click the Add button to create a new filter. Here we have a filter called "default filter".

 

filterman2

 

A filter is composed by columns and a query. The columns you choose here will be displayed in the data grind in Inventory Overview.

 

filterman3

 

You do not need to specify a query, it is optional. However, you will need to do so if you want to limit the amount of information to display in the data grid. By using the Expression Build you can easily build queries that suits you needs.