<< Click here to display whole document >> Data filtering |
Filters represent powerful tool for data presentation. You can restrict displayed data by defining filtering conditions in Filter definition form. You can define one unique filter for each of following sections.
Plans
Plan stocks
Plan parts
Materials
Material stocks
Material parts
Assemblies
Assembly parts
Storages
Storage stocks
Edge bandings
Machines
By clicking the button in the main toolbar or by pressing keyboard shortcut Ctrl+F the Filter definition form opens in new window.
Filter definition form may contain more filtering conditions. Define logical relation among these conditions by clicking one of following radio buttons.
All of the conditions |
Only data which fulfill all of the defined conditions will be displayed. |
Any of the conditions |
Only data which fulfill at least one of the defined conditions will be displayed. |
You can add and delete conditions of filter by clicking the chosen button.
Functions of the buttons for manipulation with the filter are described as follows.
More |
New condition will be added at the end of already defined conditions. It is possible to define 9 conditions at most. |
|
Fewer |
The last condition in the filter will be deleted. |
|
Clear all |
All defined conditions will be deleted. |
You need to choose a column, operation and define the value for each of conditions.
Select column from pre-defined list of available columns. You can define conditions even for columns not displayed in given data grid.
Tip: Select Any field value from the list if you need to define condition for all available columns. |
Select operation from pre-defined list of operations and enter the value for setting the filter.
Note: Use numeric value for numeric columns like Plan ID or Qty. For other columns any string can be used. |
When all conditions of the filter are set, you can activate it. For activation click the check box Active in the Filter definition form.
The filter will display only the records which fulfill defined conditions. Activation of filter is signalized by the red labeled information in toolbar.
Tip: It is possible to apply both, filter and data multiselection, when working with data. |