Test Case Execution Record
Test Case Execution Record is an element in the IBM Engineering Lifecycle Management data dictionary that you can use for mapping test artifacts.
| UI Element | UI Field | REST API Resource | REST API Property Path | XDC Resource | XDC Data Mapping Table | XDC Column Name | Data Warehouse Schema | Data Warehouse Table | Data Warehouse Column | FM Model Path | FM Model Query Subject | FM Model Query Item | Description | Sample Input | Sample Output |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Test Case Execution Record | N/A | executionworkitem | N/A | N/A | N/A | N/A | N/A | EXECUTION_WORKITEM | N/A | N/A | Execution Work Item | N/A | Unless otherwise specified in this dictionary, Test Case Execution RecordUI elements are expressed by the REST API Resource URL as executionworkitem; are stored in the data warehouse EXECUTION_WORKITEMtable; and can be added to report definitions using the Execution Work Item Query Subject and related Items. |
N/A | N/A |
|
Test Case Execution Record Version Updates |
Owner | executionworkitem | /content/qm:executionworkitem/alm:owner | ExecutionWorkItem | RQMExecutionWorkItem | owner | N/A | N/A | N/A | Operational Data Store/Execution Work Item Area/ | N/A | N/A | The contributor's registered id that owns the test case execution record. | N/A | N/A |
| Test Case Execution Record | Test Case | executionworkitem | /content/qm:executionworkitem/qm:testcase/@qm:href | N/A | RQMExecutionWorkItem | testcase_uuid | ODS | EXECUTION_WORKITEM | TESTCASE_ID | N/A | Execution Work Item | Test Case ID | The MD5 encrypted value of URI of the test case of test case execution record | N/A | N/A |
| Test Case Execution Record | Name | executionworkitem | /content/qm:executionworkitem/dc:title | N/A | RQMExecutionWorkItem | title | ODS | EXECUTION_WORKITEM | NAME | N/A | Execution Work Item | Name | The name of test case execution record | N/A | N/A |
| Test Case Execution Record | N/A | executionworkitem | /id | N/A | RQMExecutionWorkItem | itemId | ODS | EXECUTION_WORKITEM | EXTERNAL_KEY2 | N/A | Execution Work Item | External Key2 | The uuid of test case execution record | N/A | N/A |
| Test Case Execution Record | EWI Frequency | executionworkitem | /content/qm:executionworkitem/executionworkitem:frequency | N/A | RQMExecutionWorkItem | frequency | ODS | EXECUTION_WORKITEM | FREQUENCY | N/A | Execution Work Item | Frequency | The number of times the test is scheduled to run | N/A | N/A |
| Test Case Execution Record | Test Plan | executionworkitem | /content/qm:executionworkitem/qm:testplan/@qm:href | N/A | RQMExecutionWorkItem | testplan_uuid | ODS | EXECUTION_WORKITEM | TESTPLAN_ID | N/A | Execution Work Item | Test Plan ID | The MD5 encrypted value of URI of the test plan of test case execution record | N/A | N/A |
| Test Case Execution Record | N/A | executionworkitem | /content/qm:executionworkitem/alm:state | N/A | RQMExecutionWorkItem | executionworkitem_state | ODS | EXECUTION_WORKITEM | EXECUTION_WORKITEM_STATE | N/A | Execution Work Item | Execution Work Item State | The actual result id of test case execution record but it only get the last word in the id and capitalize the first letter when populate it to DW DB | N/A | XDC returned value is com.ibm.rqm.execution.common.state.blocked and the value in DB is Blocked |
| Test Case Execution Record | The latest result of Previous Result Details | executionworkitem | /content/qm:executionworkitem/qm:currentexecutionresult/@qm:href | N/A | RQMExecutionWorkItem | currentexecutionresult | ODS | EXECUTION_WORKITEM | CURRENT_RESULT_ID | N/A | Execution Work Item | Current Result ID | The MD5 encrypted value of URI of the current execution result of test case execution record | N/A | N/A |
| Test Case Execution Record | N/A | executionworkitem | /content/qm:executionworkitem/executionworkitem:regression | N/A | RQMExecutionWorkItem | regression | ODS | EXECUTION_WORKITEM | REGRESSION | N/A | Execution Work Item | Regression | Indicator that this is a regression test | N/A | N/A |
| Test Case Execution Record | Weight | executionworkitem | /content/qm:executionworkitem/executionworkitem:weight | N/A | RQMExecutionWorkItem | weight | ODS | EXECUTION_WORKITEM | WEIGHT | N/A | Execution Work Item | Weight | An integer measure of the estimated effort to execute the test case execution record | N/A | N/A |
| Test Case Execution Record | Originator | executionworkitem | /content/qm:executionworkitem/executionworkitem:creator | N/A | RQMExecutionWorkItem | creator | N/A | N/A | N/A | N/A | N/A | N/A | The contributor's registered ID that created the test case execution record. | N/A | N/A |
| Test Case Execution Record | Priority | executionworkitem | /content/qm:executionworkitem/executionworkitem:priority | N/A | RQMExecutionWorkItem | priority | ODS | EXECUTION_WORKITEM | PRIORITY | N/A | Execution Work Item | Priority | The priority of the test | N/A | Acceptable values are: literal.priority.101, literal.priority.110, literal.priority.120and literal.priority.130for unassigned, low, medium and high priority respectively |
|
Test Case Execution Record Version Updates |
Last Modified | executionworkitem | /updated | N/A | RQMExecutionWorkItem | updated | ODS | EXECUTION_WORKITEM | LAST_UPDATED | N/A | Execution Work Item | Last Updated | The last updated date and time of test case execution record in UTC format | N/A | N/A |
| Test Case Execution Record | Default Test Script | executionworkitem | /content/qm:executionworkitem/qm:testscript/@qm:href | N/A | RQMExecutionWorkItem | testscript_uuid | ODS | EXECUTION_WORKITEM | TESTSCRIPT_ID | N/A | Execution Work Item | Test Script ID | The MD5 encrypted value of URI of the manual test script of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Execution Record URL | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMExecutionWorkItem | url | ODS | EXECUTION_WORKITEM | URL | N/A | Execution Work Item | URL | The URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Execution Record URL | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMExecutionWorkItem | uuid | ODS | EXECUTION_WORKITEM | EXTERNAL_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Environment | executionworkitem | /content/qm:executionworkitem/qm:configuration/@qm:href | N/A | RQMExecutionWorkItem | config_uuid | ODS | EXECUTION_WORKITEM | CONFIGURATION_ID | N/A | Execution Work Item | Configuration ID | The MD5 encrypted value of URI of the test environment of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
Iteration | executionworkitem | /content/qm:executionworkitem/qm:testphase/@qm:href | N/A | RQMExecutionWorkItem | testphase_uuid | N/A | N/A | N/A | N/A | N/A | N/A | The MD5 encrypted value of URI of the iteration of test case execution record | N/A | N/A |
| Test Case Execution Record | Default Test Script | executionworkitem | /content/qm:executionworkitem/qm:remotescript/@qm:href | N/A | RQMExecutionWorkItem | remotescript_uuid | ODS | EXECUTION_WORKITEM | TESTSCRIPT_ID | N/A | Execution Work Item | Test Script ID | The MD5 encrypted value of URI of the remote test script of test case execution record | N/A | N/A |
| Test Case Execution Record | N/A | executionworkitem | /content/qm:executionworkitem/qm:creationDate | N/A | RQMExecutionWorkItem | creationDate | ODS | EXECUTION_WORKITEM | CREATION_DATE | N/A | Execution Work Item | Creation Date | The date and time that created the test case execution record in UTC format | N/A | N/A |
| Test Case Execution Record | Is Deleted | executionworkitem | /qm:archived | N/A | RQMExecutionWorkItem | isSoftDeleted | ODS | EXECUTION_WORKITEM | ISSOFTDELETED | N/A | Execution Work Item | Is Deleted | The test case execution record is archived or not | N/A | N/A |
| Test Case Execution Record | ID | executionworkitem | /content/qm:executionworkitem/qm:webId | N/A | RQMExecutionWorkItem | webId | ODS | EXECUTION_WORKITEM | REFERENCE_ID | N/A | Execution Work Item | Reference ID | Read-only integer ID of test case execution record as seen in the web UI | N/A | N/A |
| Test Case Execution Record | Project Area | executionworkitem | /content/qm:executionworkitem/qm:projectArea/@vega:id | N/A | RQMExecutionWorkItem | projectId | ODS | EXECUTION_WORKITEM | PROJECT_ID | N/A | Execution Work Item | Project ID | The uuid of project area of the test case execution record | N/A | N/A |
| Test Case Execution Record | Owner | executionworkitem | /content/qm:executionworkitem/alm:owner/@rdf:resource | N/A | RQMExecutionWorkItem | owner_uuid | ODS | EXECUTION_WORKITEM | OWNER_ID | N/A | Execution Work Item | Owner ID | The MD5 encrypted value of URI of the contributor that owns the test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
Estimate | executionworkitem | /content/qm:executionworkitem/qm:estimate | N/A | RQMExecutionWorkItem | estimate | ODS | EXECUTION_WORKITEM | ESTIMATE | N/A | Execution Work Item | Estimate | The estimate weight of the test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
Time Spent | executionworkitem | /content/qm:executionworkitem/qm:timeSpent | N/A | RQMExecutionWorkItem | timeSpent | ODS | EXECUTION_WORKITEM | TIMESPENT | N/A | Execution Work Item | Time Spent | The time spent of the test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
Priority | executionworkitem | /content/qm:executionworkitem/executionworkitem:priority/@rdf:resource | N/A | RQMExecutionWorkItem | priority_uuid | ODS | EXECUTION_WORKITEM | TEST_PRIORITY_ID | N/A | Execution Work Item | Test Priority External ID | The MD5 encrypted value of URI of the priority of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Environment | executionworkitem | /content/qm:executionworkitem/qm:configuration/@qm:href | N/A | RQMEWI_Relationships | configuration_uuid | ODS | CONFIG_EXECUTIONWORKITM_LOOKUP | CONFIGURATION_ID | N/A | Execution Work Item Related Configurations | External ID | The MD5 encrypted value of URI of the test environment of test case execution record | N/A | N/A |
| Test Case Execution Record | Blocking Defects | executionworkitem | /content/qm:executionworkitem/qm:blockingdefects/@qm:href | N/A | RQMEWI_Relationships | blockingDefect_uuid | ODS | EXECWORKITEM_REQUEST_LOOKUP | REQUEST_ID | N/A | Execution Work Item Related Requests | External ID | The MD5 encrypted value of URI of the blocking defects of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | ODS | CONFIG_EXECUTIONWORKITM_LOOKUP | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | ODS | EXECWORKITEM_REQUEST_LOOKUP | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | ODS | EXECWORKITEM_ITERATION_LOOKUP | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | ODS | EXECWORKITEM_CATEGORY_LOOKUP | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | CALM | EXECWORKITEM_STRING_EXT | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | CALM | EXECWORKITEM_STRING_M_EXT | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | CALM | EXECWORKITEM_INT_EXT | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Test Case Execution Record | executionworkitem | /content/qm:executionworkitem/dc:identifier | N/A | RQMEWI_Relationships | uuid | CALM | EXECWORKITEM_TIMESTAMP_EXT | EXECWORKITEM_ID | N/A | Execution Work Item | External ID | The MD5 encrypted value of the URL of test case execution record | N/A | N/A |
| Test Case Execution Record | Iteration | executionworkitem | /content/qm:executionworkitem/qm:testphase/@qm:href | N/A | RQMEWI_Relationships | testphase_uuid | ODS | EXECWORKITEM_ITERATION_LOOKUP | ITERATION_ID | N/A | Execution Work Item Related Iterations | External ID | The MD5 encrypted value of URI of the iteration of test case execution record | N/A | N/A |
| Test Case Execution Record | Blocking Defect URL | executionworkitem | /content/qm:executionworkitem/qm:blockingdefects/@qm:href | N/A | RQMEWI_Relationships | blockingDefect_url | ODS | EXECWORKITEM_REQUEST_LOOKUP | REQUEST_ID | N/A | Execution Work Item Related Requests | URL | The URL of the blocking defects of test case execution record. It is used to look up for Clear Quest Requests. | N/A | N/A |
|
Test Case Execution Record Version Updates |
Category Value | executionworkitem | /content/qm:executionworkitem/qm:blockingdefects/@qm:href | N/A | RQMEWI_Relationships | valueUUID | ODS | EXECWORKITEM_CATEGORY_LOOKUP | TEST_CATEGORY_ID | N/A | Execution Work Item Related Test Categories | External Key2 | The uuid of category value of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
N/A | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier | N/A | RQMEWI_Relationships | identifier | CALM | EXECWORKITEM_STRING_EXT | IDENTIFIER | N/A | Execution Work Item String Extension | Identifying name | The identifier of small text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
N/A | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier | N/A | RQMEWI_Relationships | identifier | CALM | EXECWORKITEM_STRING_M_EXT | IDENTIFIER | N/A | Execution Work Item Medium String Extension | Identifying name | The identifier of medium text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
N/A | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier | N/A | RQMEWI_Relationships | identifier | CALM | EXECWORKITEM_INT_EXT | IDENTIFIER | N/A | Execution Work Item Integer Extension | Identifying name | The identifier of integer custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
N/A | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:identifier | N/A | RQMEWI_Relationships | identifier | CALM | EXECWORKITEM_TIMESTAMP_EXT | IDENTIFIER | N/A | Execution Work Item Timestamp Extension | Identifying name | The identifier of date/time custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Type | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/@qm:type | N/A | RQMEWI_Relationships | type | N/A | N/A | N/A | N/A | N/A | N/A | The type of custom attribute of test case execution record, there are 4 types, SMALL_STRING, MEDIUM_STRING, INTEGER, TIMESTAMP | N/A | SMALL_STRING: the type of custom attribute is Text (Small). MEDIUM_STRING: the type of custom attribute is Text (Medium). INTEGER: the type of custom attribute is Integer. TIMESTAMP: the type of custom attribute is Date/Time. |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Name | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name | N/A | RQMEWI_Relationships | name | CALM | EXECWORKITEM_STRING_EXT | NAME | N/A | Execution Work Item String Extension | Name | The name of small text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Name | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name | N/A | RQMEWI_Relationships | N/A | CALM | EXECWORKITEM_STRING_M_EXT | NAME | N/A | Execution Work Item Medium String Extension | Name | The name of medium text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Name | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name | N/A | RQMEWI_Relationships | N/A | CALM | EXECWORKITEM_INT_EXT | NAME | N/A | Execution Work Item Integer Extension | Name | The name of integer custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Name | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:name | N/A | RQMEWI_Relationships | N/A | CALM | EXECWORKITEM_TIMESTAMP_EXT | NAME | N/A | Execution Work Item Timestamp Extension | Name | The name of date/time custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Value | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value | N/A | RQMEWI_Relationships | value | CALM | EXECWORKITEM_STRING_EXT | VAR | N/A | Execution Work Item String Extension | Value | The value of small text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Value | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value | N/A | RQMEWI_Relationships | value | CALM | EXECWORKITEM_STRING_M_EXT | VAR | N/A | Execution Work Item Medium String Extension | Value | The value of medium text custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Value | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value | N/A | RQMEWI_Relationships | value | CALM | EXECWORKITEM_INT_EXT | VAR | N/A | Execution Work Item Integer Extension | Value | The string type value of integer custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Attributes Version Updates |
Custom Attribute Value | executionworkitem | /content/qm:executionworkitem/qm:customAttributes/qm:customAttribute/qm:value | N/A | RQMEWI_Relationships | timeValue | CALM | EXECWORKITEM_TIMESTAMP_EXT | VAR | N/A | Execution Work Item Timestamp Extension | Value | The string type value of date/time custom attribute of test case execution record | N/A | N/A |
|
Test Case Execution Record Version Updates |
Is Deleted | executionworkitem | /qm:archived | N/A | RQMEWI_Relationships | isSoftDeleted | CALM | EXECWORKITEM_STRING_EXT | ISSOFTDELETED | N/A | Execution Work Item String Extension | Is Deleted | The test case execution record is archived or not | N/A | 0: not deleted, 1: deleted |
|
Test Case Execution Record Version Updates |
Is Deleted | executionworkitem | /qm:archived | N/A | RQMEWI_Relationships | isSoftDeleted | CALM | EXECWORKITEM_STRING_M_EXT | ISSOFTDELETED | N/A | Execution Work Item Medium String Extension | Is Deleted | The test case execution record is archived or not | N/A | 0: not deleted, 1: deleted |
|
Test Case Execution Record Version Updates |
Is Deleted | executionworkitem | /qm:archived | N/A | RQMEWI_Relationships | isSoftDeleted | CALM | EXECWORKITEM_INT_EXT | ISSOFTDELETED | N/A | Execution Work Item Integer Extension | Is Deleted | The test case execution record is archived or not | N/A | 0: not deleted, 1: deleted |
|
Test Case Execution Record Version Updates |
Is Deleted | executionworkitem | /qm:archived | N/A | RQMEWI_Relationships | isSoftDeleted | CALM | EXECWORKITEM_TIMESTAMP_EXT | ISSOFTDELETED | N/A | Execution Work Item Timestamp Extension | Is Deleted | The test case execution record is archived or not | N/A | 0: not deleted, 1: deleted |