Data filtering

<< Click here to display whole document >>

Program overview >

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

Filter definition

By clicking the button filter_24 in the main toolbar or by pressing keyboard shortcut Ctrl+F the Filter definition form opens in new window.

1D_Filtering

Filter definition form may contain more filtering conditions. Define logical relation among these conditions by clicking one of following radio buttons.

XD_FilterMatch

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.

Adding and deleting the conditions

You can add and delete conditions of filter by clicking the chosen button.

XD_FilterAddDell

Functions of the buttons for manipulation with the filter are described as follows.

XD_FilterMore

More

New condition will be added at the end of already defined conditions. It is possible to define 9 conditions at most.

XD_FilterFewer

Fewer

The last condition in the filter will be deleted.

XD_FilterClearAll

Clear all

All defined conditions will be deleted.

Defining and editing the conditions

You need to choose a column, operation and define the value for each of conditions.

XD_FilterConditions

Select column from pre-defined list of available columns. You can define conditions even for columns not displayed in given data grid.

XD_FilterComboBox1

XD_MsgTip

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.

XD_FilterComboBox2

XD_MsgNote

Note: Use numeric value for numeric columns like Plan ID or Qty. For other columns any string can be used.

Activation and deactivation of filter

When all conditions of the filter are set, you can activate it. For activation click the check box Active in the Filter definition form.

XD_FilterActive

The filter will display only the records which fulfill defined conditions. Activation of filter is signalized by the red labeled information in toolbar.

1D_FilterDisplay

XD_MsgTip

Tip: It is possible to apply both, filter and data multiselection, when working with data.