TDM Find & Reserve Model "IS NULL" Default Value Behavior

Products

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

Issue/Introduction

When configuring a Find & Reserve (F&R) Model in TDM Portal, setting a default value of IS NULL for a table column does not behave as an operator. Instead:

• The tester sees the literal string "IS NULL" in the search field.
• Running the query with this default returns no data because the system searches for the literal text instead of identifying null database values.
• Data is only returned if the tester manually selects the IS NULL operator from the dropdown menu in the F&R form.

Environment

• Product: CA Test Data Manager (TDM)
• Component: TDM Web Portal (Find & Reserve)
• Version: All current versions supporting F&R Models

Cause

The DEFAULT field in the F&R column configuration is designed to store and display a string literal. It is not an operator field. Functional operators (such as IS NULL, LIKE, =, or >) are provided via the operator dropdown in the end-user F&R form and are not currently supported as pre-configured functional defaults in the column metadata.

Resolution

This is a design limitation. To retrieve null values, the user must explicitly select the IS NULL operator from the operator dropdown menu on the Find & Reserve search screen.

Enhancement Request

An enhancement request has been logged to allow functional operators to be set as defaults or to provide a way to 'fix' these filters so they cannot be edited by the tester.

• Reference ID: US1111562

Workaround

Educate testers to manually select the IS NULL operator from the search criteria UI if they need to filter for null values. If data restriction is the primary goal, consider using a database view as the source for the F&R model to pre-filter data at the schema level.