search cancel

Compound key in Find and Reserve


Article ID: 211774


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


I'm building a simple Find & Reserve model using two tables. Those two tables are related via a compound key. When adding fields for the second table, we eventually need to choose the existing relationship. Here, I just want to validate the following points:
-I have to choose one and only one relationship to build the relationship inside the F&R model.
-The behavior might differ according to the chosen relationship

In the case of multiple relationships, is there a way to choose multiple relationships? Or, in a more general way, how can F&R treat compound keys inside a model?


Release : 4.9.1

Component : CA Test Data Manager - TDM Web Portal


From the UI, we only support one of the composite keys. In this case, the query that is built in the backend will use the chosen relationship rather than the composite key when joining the two tables.

However you will be able to create a Find and Reserve model that uses the composite key by using swagger directly.

You should provide the whole composite key when creating the association

In my case I used department as root entity and ....

CREATE TABLE dbo.department
    id int NOT NULL,
    name nvarchar(50) NOT NULL,
    location nvarchar(50),

    CONSTRAINT PK_dbo_department_id_name

CREATE TABLE dbo.person
    id int NOT NULL,
    name nvarchar(50) NOT NULL,
age int,

    dept_id int,
    dept_name nvarchar(50),

    CONSTRAINT PK_dbo_t2_id_name

    CONSTRAINT FK_dbo_t2_t1_id_name
    FOREIGN KEY (dept_id, dept_name)
    REFERENCES dbo.department (id, name)


The request call 


had the following payload 


Is there a way to create more than one field at the time or one call = one field ?  One call - One field.