How to create a query to list upstream traces

[byoung]

Integrity 10.6

I've constructed a test protocol with a series of cases (tests). Upstream trace relationships have been added to the Requirements the cases validate. I am able to insert a "validates" field into my protocol, but am unable to "export" or "report" the Requirement content--only the ID number of the traced requirement.

How can I configure my export to pull that additional information OR how can I write a query that will return a discrete list (no duplicates) of the Requirements.

Currently the export looks like....

<%beginLevel 1%>

<%if {Category} == "Heading"%>

<%{Text}richcontent="false"%>

<%elseif {Category} == "Comment"%><%{Text} richcontent="false"%><%else%>

Section	Item	Case Type	Case/Step	Req. Trace(s)
<%{Section}%>	<%{ID}%>	<%{Category}%>	<%{Text} richcontent="false"%>	<%{Validates}%>

<%endif%><%endLevel%><%beginLevel 2%><%if {Category} == "Heading"%>

<%{Text}richcontent="false"%>

<%elseif {Category} == "Comment"%><%{Text} richcontent="false"%><%else%>

<%{Section}%>

<%{ID}%>

<%{Category}%>

<%{Text}%>

<%{Validates}%>

<%endif%><%endLevel%><%endContent%>

[KaelLizak]

Hello Bob,

In general, this would be much easier to implement with a report recipe than with a document export:  report functionality supports walking tree structures, while document export only exports the contents of a single doucment.  There is a section on Query and Walk Functions in the PTC Integrity 10.6 Server Administration Guide, on page 592.

If you have access to report recipes from the ALM solution, you may want to base this off one of the report recipes in that solution set:  ALM_Document Traces.

Regards,
Kael