Is it possible for me to print a large number of Manual Tests and Steps all at the same time?

0 Likes

Problem:

Is it possible for me to print a large number of Manual Tests and Steps all at the same time?

Resolution:

It is possible to print all these tests and steps as one document by working with the Reports Unit in SilkCentral Test Manager.

Follow the steps below to create a report that will allow you to print all your manual tests.

  1. Open SilkCentral Test Manager.
  2. Navigate to the reports unit.
  3. Right Click on a Test Folder and select New Child Report.
  4. Select Advanced Query.
  5. Enter the name and description of your report
  6. In the Report Data Query text field enter the SQL query as shown below. (The SQL statement has been pasted below for your convenience).
  7. Select finish.



Your new report will now be included in the folder you selected. Select the folder and you can choose to download it
in a number of formats which allow you to print all the information requested in the query.

SQL Statement

        SELECT mtd.TestDefID_pk_fk AS ManualTestDefID, ms.StepID_pk AS StepID, NULL AS TestDefExecID, td.TestName AS "Test Definition Name", ms.Name AS "Step Name", ms.Description AS "Description", ms.Result AS "Expected Result"

FROM TM_V_TestDefinitions td

INNER JOIN TM_ManualTestDefinitions mtd

ON (td.TestID = mtd.TestDefID_pk_fk)

LEFT JOIN TM_ManualSteps ms ON (mtd.TestDefID_pk_fk = ms.ManualDefinitionID_fk)

WHERE td.ProjectID=${$PROJECTID}

ORDER BY td.TestName



Old KB# 24655
Comment List
Anonymous
Related Discussions
Recommended