Edit Test Case Data Criteria

Test Case Data Criteria (TCDC) is a logical table stored inside the Datamaker repository (static data pool) containing one row per test case. Each row defines one or more query criteria that define the test case's data requirements for a given test data entity. Also specifies whether each test case requires an exclusive or a shared lock on the matched test data entity instance (i.e. whether the test case updates the underlying data for that instance, or whether it only reads it).
tdm10
Test Case Data Criteria (TCDC) is a logical table stored inside the Datamaker repository (static data pool) containing one row per test case. Each row defines one or more query criteria that define the test case's data requirements for a given test data entity. Also specifies whether each test case requires an exclusive or a shared lock on the matched test data entity instance (i.e. whether the test case updates the underlying data for that instance, or whether it only reads it).
 
Follow these steps:
 
  1. Expand the project in which you created the Data Pool with type as Test Match.
  2. Double click the Data Pool, and click Edit Data.
  3. Expand the Registered Objects tree view, locate Used Tables, and click TESTCASE_DATA_CRITERIA.
  4. Add as many test cases as you want to match with the test data. Add a separate row for each test case.
    If TDM is integrated with HP ALM, the test name in ALM and TCDC must be the same. The test name is case sensitive.
  5. Go to each test case row and click on each column to provide the test case data criteria for the respective test case. Optionally double click on each column to open the editor window. Enter the values in the editor window for respective column and click validate. Verify that the value you entered is valid and then click Save.
    Following are the mandatory columns for each test case: 
    •  
      Test Repeater
      Specifies the amount of test data you want to have for the given test condition.
    •  
      Test Conditions
      Specifies the test conditions to apply on the primary key columns in the testmart properties. The conditions you enter in these columns form the WHERE clause for matching the data. The TCDC table has 20 columns for specifying the test conditions.
      • The test conditions you enter in these columns result in "
        AND"
         conditions. For example, if you enter "salary < 1000" in "Test Conditions" column and "age > 30" in "Test Conditions2" column, then the final test condition becomes "where salary < 1000 
        AND
         age > 30".
      • If you want to specify "
        OR
        " conditions among testmart columns, then enter your complete test condition only in the "TEST CONDITIONS" column. Do not use multiple test conditions columns.
      • Do the following to enter or edit the values in each test conditions column:
        1. Double-click on the 
          Test Conditions
           column.
          The editor window opens.
        2. Enter the test condition in the text box on the editor window.
        3. Click the 
          Validate WHERE clause in Test Match Pool
           button to verify whether the test condition you entered is valid or not.
        4. Click the 
          Count number of 
           
          occurrences
           button to see the matched row count for the test condition you entered.
        5. Click 
          Save
          .
          The values you entered are saved in the respective test conditions column for the corresponding test case.
    •  
      Test Override Priority
      •  
        Default:
         99
      •  
        Range:
         1 – 99.
        1 sets the highest priority and 99 sets the lowest priority.
    •  
      Test Locking
      •  
        Default:
         LK
      •  
        Available options:
         LK and RS
        LK:
         Specifies Exclusive Lock. Rows that have LK (Exclusive Lock) for a test case cannot be allocated to another test case, even if they meet all the other criteria.
        RS: 
        Specifies Read Share. Rows that have RS (Read Shared Lock) can be additionally allocated to other test cases that only require read shared locks, but not to test cases requiring an exclusive lock.
  6. Click the Save icon.