Skip to main content
nborrerojr.1-Visitor
1-Visitor
Nov 8, 2016 11:27 PM UTC
Question

Relational Queries

Is there any way to do a relational query with ILM data other than using a report recipe? If not, is there by any chance an add-in for Access or something similar that will treat item types as tables to allow relational queries to be created?

    7 replies

    VolkerEckardt17-Peridot
    17-Peridot
    Nov 13, 2016 12:28 PM UTC

    Hello Nolin,

    could you please tell us your Use Case that we can better understand what you are trying to achieve? Further more, could you give us an example?

    Translate
    nborrerojr.1-VisitorAuthor
    1-Visitor
    Nov 14, 2016 5:47 PM UTC

    It makes more sense for our specific configuration, but to use an example with the default ALM config, it would be something like this:

    For each Requirement within a Requirement Document, I'd want to see every Test Suite that is related to a Requirement based on a trace to a Test Case.

    The problem that I'm going to run into is that the Test Suite will be returned multiple times if there are multiple Test Cases within it traced to a single Requirement.

    req to test case.png

    So what I'm looking for would be just a standard SQL query I could run where I can use things like Select Distinct and also just have the simplicity of a query builder. What I think would be great would be an add-in for access that would use the API to return queries and would treat each item type as a separate table.

    Translate
    VolkerEckardt17-Peridot
    17-Peridot
    Nov 14, 2016 5:53 PM UTC

    Hi Nolin,

    last question before I will try to answer:

    How should the output look exactly?

    And, should it be inside Integrity or a report (I am not clear about this)

    When you have it, what do you do with this then (Business Value)?

    Translate
    Terms & ConditionsAccessibility statement