Skip to main content
Delphix

Rule Set Feature: Filter (KBA4453)

 

KBA

KBA# 4453

At 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: 
  • Where: The WHERE clause. 
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. 

UI RS - FC.png

Edit Table Settings popup 

This shows an example using Filter on the column 'MY_FILTER_COLUMN'. 

UI RS - Popup - Filter.png

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. 

Related Articles