Skip to main content
P
ptc-53513251-Visitor
1-Visitor
November 1, 2013
Solved

Amalgamating linked documents

  • November 1, 2013
  • 1 reply
  • 1532 views

Hi All,

I'm looking at taking two documents that are linked together in Integrity and displaying them together as if they had a relationshipp in a relational database. The only way I've found of doing this is by exporting the data for both documents, running code to create a new line for each value in the 'linked' field and then joining the tables using SQL. (I don't have access to the database for running SQL queries directly so I have to parse the data)

I'm a new user and would like to know if there's any way to do this within the Integrity tool itself? For instance, if I have a requirement and it's linked to 3 test cases, my query will return this:

12345 | Requirement Summary| 50001, 50003, 50005

I would like an output more like this:

12345 | Requirement Summary | 50001 | Test Case Description 1

12345 | Requirement Summary | 50003 | Test Case Description 2

12345 | Requirement Summary | 50005 | Test Case Description 3

I imagine this is a regular request, but I'm not familiar enough with the tool to produce a query that will allow this output.

Any Ideas?

Thanks,

Rich

    Best answer by KaelLizak

    Hello Rich,

    Welcome to the community!

    Based on your example, I assume you have the ALM solution installed. For this sort of issue, look at the report called Document Structure Traces - Tree View.

    1. Open the document, or select the document from a query
    2. From the Document menu, select Run Report... (keyboard shortcut: Ctrl + Shift + R)
    3. The Report Selection dialog will pop up:
      1. Type Tree View in the text filter at the top
      2. Select Document Structure Traces - Tree View from the list.
      3. Hit Enter or click OK
    4. The Report Selection dialog will disappear, and the report will appear in your browser:
      1. Search for 12345
      2. The entries immediately below 12345 should beTest Cases 50001-50003

    Regards,

    Kael

    1 reply

    K
    KaelLizak16-PearlAnswer
    16-Pearl
    November 1, 2013

    Hello Rich,

    Welcome to the community!

    Based on your example, I assume you have the ALM solution installed. For this sort of issue, look at the report called Document Structure Traces - Tree View.

    1. Open the document, or select the document from a query
    2. From the Document menu, select Run Report... (keyboard shortcut: Ctrl + Shift + R)
    3. The Report Selection dialog will pop up:
      1. Type Tree View in the text filter at the top
      2. Select Document Structure Traces - Tree View from the list.
      3. Hit Enter or click OK
    4. The Report Selection dialog will disappear, and the report will appear in your browser:
      1. Search for 12345
      2. The entries immediately below 12345 should beTest Cases 50001-50003

    Regards,

    Kael

      P
      ptc-53513251-VisitorAuthor
      1-Visitor
      November 4, 2013

      Thanks Kael,

      The report I require needs different information but you certainly helped point me in the right direction! I'm coming from the SQL world where you must first build a query in order to build a report... I see that in ALM I can build a report directly with the info I need!

      Either way, your reply was very helpful and much appreciated!

      Best Regards,

      Rich

      Terms & ConditionsAccessibility statement