Data grid filter settings

Data grid filter settings
Prev	Filter settings window	Next

> > > > > >

Tillypad XL Manager interface elements

Data grid filter settings

To add a new filter condition, press the Click to add a new condition button.

Figure 3.110. Button menu

Menu commands of the Filter or '...' buttons:

Add condition – creates a new filter condition,
Add group – creates a new filter condition group,
Delete row – deletes the filter condition or group.
If the Delete row command is selected in the button menu of an individual filter condition, only the given filter condition will be deleted from the list. If the command is selected from the button menu of a filter condition group, this group will be deleted along with all of its nested groups and conditions.

For a group of conditions, a Boolean operator is specified to connect the associated filter conditions and their groups.

You can select one of the following Boolean operators: and, not...and, or, and not...or.

Figure 3.111. Logical operations drop-down list

For the filter condition, you must specify: data grid column, comparison operator, and reference model.

Figure 3.112. Field with a drop-down list of data grid columns

The list of operators includes equal to and not equal to for each field type.

Suppose you need to filter the data grid of the Menu units of measurement directory such that it will display only the units of measurement that belong to the Quantity class.

Figure 3.113. Filter setting to select entries by their value

Figure 3.114. View of the directory window after filtering

The list of operators for numeric and date and time fields also includes the following operators: greater than, less than, greater than or equal to, and less than or equal to.

Figure 3.115. Comparison operations for numeric values, dates, and times

The list of operators for text fields also contains the like and not like operators, which check whether the entered mask corresponds to any samples.

Figure 3.116. Operators for string values

When performing a mask check, you can use pattern symbols to replace individual symbols or their sequences.

Pattern symbol	Description
_(underscore)	Replaces any individual symbol.
%	Replaces a sequence of any number of symbols including leading and trailing spaces.
[]	Sets up a filter for entries containing one of the following symbols, e.g. [apzv].
[^]	Sets up a filter excluding certain symbols, e.g. [^rtf].

Let us consider examples of filter masks.

Example 1

From the Stock items directory, you need to select all stock items that start with the letter 'М'. The length of the stock item name must not exceed 4 characters.

To fulfill this condition, you need to enter a string that contains the 'М' symbol, three underscores, space, and the percent sign. The three underscores can stand for any three symbols following the letter 'М'.

Figure 3.117. Example of mask filter settings

Figure 3.118. View of the directory window after filtration

Example 2

Suppose you want the Devices directory to display only devices with the letters 'POS' in their names. Let us enter the corresponding mask in the Filter settings window:

Figure 3.119. Example of mask filter settings

Figure 3.120. View of the directory window after filtration

Example 3

Suppose you want to view only employees whose surnames start with letters 'N' or 'A' in the Employees directory. Let us enter the corresponding mask in the Filter settings window:

Figure 3.121. Example of mask filter settings

Figure 3.122. View of the directory window after filtration

Example 4

Suppose you want the Stock items directory to display only stock items starting with 'C' and with a second letter other than 'o'. Let us enter the corresponding mask in the Filter settings window:

Figure 3.123. Example of mask filter settings

Figure 3.124. View of the directory window after filtering