You can create an entity with tables in a data set. When you create an entity, you select the driving table. Test Data Manager retrieves the related tables in the data set based on the constraints. You can add filter criteria to the driving table to filter source data when you create the subset of the data set. You can disable relationships between tables in the entity.
Open the required data set.
Related Data Sets
and open the
dialog box, enter a name and optional description for the entity.
to select a driving table from the list.
Test Data Manager adds the related tables to create the entity and displays a diagram of the relationship between the tables in the entity. You can view a list of the tables or a list that shows the relationships between the tables.
To create a subset of the data based on filter criteria, click
dialog box appears.
To add criteria for a column, click the
Select the columns on which you want to filter data and click
The columns that you select appear in the columns list in the
To define the filter expression in the entity, select the attribute from the Attribute list. Choose
to enter a value or
to enter a parameter name.
You can indicate a filter condition in the entity, but define the expression in the plan. You can choose to create multiple criteria with parameters and include required parameters when you run a workflow.
Select an operator from the list to filter the data.
If you enter a filter condition, enter a specific value or choose the variable from the list of variables to complete the filter expression.
for each filter criteria that you create. If you define multiple filters in an entity, the filter conditions act as "AND."