Exclude type Undefined datatype from MongoDB masking

Products

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

Issue/Introduction

We are trying to exclude the field data from masking where type is undefined, let us know what where condition we can use in the Portal.

{ $exists: true, $not: { $type: "undefined" } }

Field name: <Top-Level-Field>.extSysResourceDetails.<Specific-Field>

Environment

All supported TDM releases.

MongoDB database.

Resolution

Such types of WHERE conditions are not supported in FDM.  Only MongoDB document properties are supported for comparison, not meta-properties