Query to extract all test steps of a test set in QC dashboard




SELECT CYCLE.CY_CYCLE AS TEST_SET,


TEST.TS_NAME AS TEST_NAME,

TEST.TS_TYPE AS TEST_TYPE,

DESSTEPS.DS_STEP_NAME AS STEP_NAME,

DESSTEPS.DS_DESCRIPTION AS STEP_DESCRIPTION,

DESSTEPS.DS_EXPECTED AS STEP_EXPECTED_RESULT



FROM TESTCYCL, TEST, CYCLE, DESSTEPS

WHERE TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID AND

TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID AND

TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID AND

CYCLE.CY_CYCLE = 'Test Set name'

ORDER BY CYCLE.CY_CYCLE,TEST.TS_NAME,DESSTEPS.DS_STEP_NAME

Comments

Popular posts from this blog

XPATH for IE / internet explorer

All time good software testing books!