Rule Set Feature: Filter (KBA4453)
KBA
KBA# 4453At a Glance
Versions: | Applicable Delphix Masking versions: 4.x, 5.0.x, 5.1.x, 5.2.x, 5.3.x |
---|---|
Description: | Used to Filter and mask only specified data which match specified WHERE clause. |
Location: | UI: Rule Set > Edit Table Settings > Edit Filter API: [not available] |
Configuration: | The following parameters are configured in this feature:
|
RS Indicator: | Table Indicator in the Rule Set: 'FC'. |
Filter Usage
Used to Filter and mask only specified data which match specified WHERE clause. In earlier versions, it is critical that the filter text entered in the popup box not end with or contain any newline characters. This will cause odd behavior with the GUI and will require a support interaction to clear up.
UI Examples
In the examples below have the following names been used:
- Rule Set: 'Rule Set Features RS'
- Original Tabe Name: 'Main_Table'
Rule Set page
Please note the 'FC' indicator when the table has a Filter defined.
Edit Table Settings popup
This shows an example using Filter on the column 'MY_FILTER_COLUMN'.
No Invalid input error
Not that there is no verification if the Filter is valid or not. It is assumed that SQL is valid and that it can be used in the Masking Job.