At a Glance
|Deprecated:||This feature is deprecated in and from version 18.104.22.168.|
|Versions:||Applicable Delphix Masking versions: 4.x, 5.0.x, 5.1.x, 5.2.x, 5.3.x, 6.x (to 6.0.5)|
|Description:||Use this feature to select a list of values (stored in a file) to use for filtering data in a table column.
The filter used is IN (a,b,c...x,y,z).
|New method:||Use Custom SQL instead with WHERE [column] IN (a,b,c...).
|Location:||UI: Rule Set > Edit Table Settings > List
API: [not available]
|Configuration:||The following parameters are configured in this feature:
|RS Indicator:||Table Indicator in the Rule Set: 'LST'.|
List Usage (old deprecated method)
This feature was used to filter and select data to be masked from a file. The file can, for example, contain IDs that should be masked. The values should be one value per row.
- Create a file with values to use in the filter (values to be selected).
- Crete the Rule Set and define:
- Column to filter against (the values selected should be in this column).
- Select the file.
The SQL statement generated in the background is:
SELECT [id_col], [mask_col1], ... FROM [table] WHERE [filter_col] IN ([values in the file]);
In the examples below have the following names been used:
- Rule Set: 'Rule Set Features RS'
- Original Table Name: 'Main_Table'
Rule Set page
Please note the 'LST' indicator when the table has a List defined.
Edit Table Settings popup
This shows an example of creating a filter using column 'Mask' with filter values from the file 'in_list_file.txt'.
Missing input error
There are two different errors:
- "Please select a column name."
- "Please browse a file."
The missing file is shown below.
New Method - Custom SQL
The new method is to use Custom SQL. This is exactly the same procedure using the List where the List would generate this in the background.
The benefit with Custom SQL is also that it can be set using the API - this means that the filter can be dynamic.
The SQL to use is:
SELECT [id_col], [mask_col1], ... FROM [table] WHERE [filter_col] IN (a,b,c,...);
For more details about Custom SQL, please see the docs below.