Unable to update reference lookup for column value

book

Article ID: 220640

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

While performing data generation we use NEXTVAL Sequence function for the parent table. For the child tables we used reference lookup using the tablename and columnname.

We have created the variable and While publishing the data to target environment for single value, it is updating fine and if we use multiple values, the column value is getting duplicated in child tables with 1st record value.

Currently, we are using 4.9.333.0 version of CA Portal.

 

 

Environment

Release : 4.9.1

Component : CA Test Data Manager - Others

Resolution

We have discussed this with Level 2 Developer and unfortunately you are attempting to use the product beyond it's current capabilities.  We do not have a method in place to do variables inside of references.  To enable this would require a program framework re-design.  This is a 4-8 month endeavor that is not currently slated for a time slot in the Development Sprints.

Level 2 Developer did suggest a more direct mapping model which is given below but it is not as dynamic as you had hoped for:

As discussed here are the snapshots showing 1 -> 2 -> 4  data generation across three tables
 
image.png
image.png