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 to edit 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 variable table. 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 variable table. 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 variable table. The texts are compared using the
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 editor of
Pma objects on the "
PmaObject > Data" tab.