Tuesday

Export Test Steps from QC to excel



  1. Go to Dashboard in QC and under Analysis Tab , select the option New Excel Report.
  2. Enter the below query in the Query Area:
          Select TS_TEST_ID,TS_NAME,TS_DESCRIPTION,DS_STEP_ORDER,DS_STEP_NAME,
          DS_DESCRIPTION,DS_EXPECTED
          FROM TEST,DESSTEPS
          where TEST.TS_TEST_ID = DESSTEPS.DS_TEST_ID
          and TEST.TS_TEST_ID in (xxxx,xxxx)
          ORDER BY TS_TEST_ID, DS_STEP_ORDER

    3.   Click on the Generate button


Note: xxxx,xxxx should be replaced by test case ids. You can know your test case ids from the test plan module.

No comments:

Post a Comment