Row filter - configuration window

Description:

The window serves for creating, deleting, selecting and editing row filters. The window consists of two parts.
The left part shows the list of row filters.
The right part is used for editing the properties of the currently selected filter.

The filter list contains two system row filters $current and $all, which cannot be deleted, renamed or moved to another position. The $current system filter represents the currently displayed rows in the table of variables. This filter is automatically activated, e.g. after displaying only selected rows using the option in the menu "Row/cell context menu > Show only selected rows". The system filter $all will display all rows in the table of variables. All row filters created by the designer are saved in the application INI file and can be used in variable tables of other Pma objects.

Each row filter contains a filter condition in the form of a JavaScript expression that specifies which rows will be displayed. When the condition is evaluated, a comparison is made between the search text and the value of the variable or data extension property. If the searched text is found for the match type, then the condition is satisfied and the row is displayed in the table of variables. The texts are compared using the Pm.StringCmp method. By inserting the logical operators AND or OR between each filter condition the resulting condition can be composed of any number of sub-conditions to test several properties of a variable at once.

This configuration window can be opened by the "

" button or in the menu "Row/cell context menu > Row filter ..." in the Pma objects editor on the "PmaObject > Data" tab.

Buttons of the filter list:

	Opens the "New row filter" configuration window. After entering a name and setting filter parameters, it adds a new filter into the list after the currently selected filter.
	Deletes the selected row filter from the filter list. The system row filters $current and $all cannot be deleted.
	Moves the selected row filter up in the filter list. The system row filters $current and $all cannot be moved.
	Moves the selected row filter down in the filter list. The system row filters $current and $all cannot be moved.

Row filter configurators:

Filter name	Row filter name.
Filter condition	Row filter condition in the form of JavaScript expression.
	Adding a new row filter condition. Add filter condition - Opens the "New filter condition" configuration window. After setting the condition parameters, the text of the new condition is added to the end of the current JavaScript expression. Add selected rows as filter condition - Adds a condition to the end of the current JavaScript expression, that tests whether the variable name is equal to the name of one of the currently selected variables. This allows you to create a filter that displays only the currently selected rows.