Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How can I create Links to Requirements, Data definitions or Execution Definitions when previewing reports in SCTM?

How can I create Links to Requirements, Data definitions or Execution Definitions when previewing reports in SCTM?

Problem:

How can I create Links to Requirements, Data definitions or Execution Definitions when previewing reports in SCTM?

Resolution:

As of SCTM 2008 R2, you can access the requirements, test definitions, or execution definitions that you query, directly from the results list in the Data tab. To do so, your query must include the column ProjectID and the respective ID of the element that you want to link to:

- ReqID: Query for this column to enable a link to requirements on the Data tab of a report.
- TestDefID: Query for this column to enable a link to test definitions on the Data tab of a report.
- ExecDefID: Query for this column to enable a link to execution definitions on the Data tab of a report.

If the query"s result includes both the ProjectID and either of RequID, TestDefID, or ExecDefID, using exactly these terms as column names, the Data tab will display the values.

For example:-
The "All Requirements" report (SCTM | Reports | Requirements | Document Reports) in SCTM returns the ReqID but doesnt return the ProjectID. Therefore there will be no link created to the requirement. See below:-



To create a link to the requirement for this report, follow the steps below:-

1. Right-click and edit the “All Requirements” report and add “Project ID”



2. Click Check SQL and Finish

3. Click on Update

4. Click on the Data tab and you will see the Project ID column added to the report. The fields in the ReqID column should be highlighted in blue indicating a link to the requirement.


5. Click on one of the ReqID links and this will bring you to the corresponding Requirement in the Requirements module.


Old KB# 25138

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:53
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.