Skip to main content
N
nborrerojr.1-Visitor
1-Visitor
November 8, 2016
Question

Relational Queries

  • November 8, 2016
  • 1 reply
  • 3542 views

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?

    1 reply

    V
    VolkerEckardt17-Peridot
    17-Peridot
    November 13, 2016

    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?

    N
    nborrerojr.1-VisitorAuthor
    1-Visitor
    November 14, 2016

    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.

    V
    VolkerEckardt17-Peridot
    17-Peridot
    November 14, 2016

    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)?

    Terms & ConditionsAccessibility statement