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