TDM: Masking function For JSON file, using the HASDOB function is not working

book

Article ID: 192560

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The HASHLOV function in the JSON string is working, but the HASHDOB did not change the date.

 

Below is the sample from the audit log

 

Client,,,ClientInfo,$['FirstName'],"HASHLOV",....

Client,,,ClientInfo,$['MiddleName'],"HASHLOV",....

Client,,,ClientInfo,$['LastName'],"HASHLOV",....

Client,,,ClientInfo,$['BirthDate'],"HASHDOB","1957-03-29T00:00:00","1957-03-29T00:00:00"

Environment

Release : 4.9

Component : CA Test Data Manager - Fast Data Masker

Resolution

You just miss the important part of HASHDOB for strings, the date format. Please, update the mask file adding the DATE FORMAT.



For the provided data, I used the following, and works for me:

yyyy-MM-dd'T'HH:mm:ss





Just update the field immediately after Y into mask definition file as we can see bellow: