Issue with Parquet File Masking in HASLOV when using WHERE clause with NOT IN and parentheses around the data

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Issue with Parquet File Masking in HASLOV when using WHERE clause with NOT IN and parentheses around the data.

Example: ‘Virgin Islands (British)’, 'Virgin Islands (U.S.)'

 

Environment

FDM 5.0.1.0

Cause

Invalid WHERE condition with parentheses in list values.

Resolution

Open a support case and refer to defect DE669446 to get FastDataMasker-5.0.2.0.zip or later, which resolves issue along with changes to the WHERE clause:

NOTE: Need to change your WHERE clause to this: (leave out the WHERE, FDM adds it)

country NOT IN ('(Virgin Islands (British))', '(Virgin Islands (U.S))')

See example below: