Skip to main content
1-Visitor
November 13, 2015
Solved

How do I create a query that gives me all Problem reports that have change packages closed since a specific date?

  • November 13, 2015
  • 2 replies
  • 1930 views

Our problems have one or more work instructions that have one or more change packages associated with them.  I can query to get a list of all work instructions that have changes packages closed since the specified date but I cannot get back to the list of problem reports associated with these work instructions

    Best answer by tketz

    Hi,

    this is not possible from Queries (i think there are many RFC for that business case).

    You cann get the Information, using your query and create a report with the backward relationships (parent).

    2 replies

    MarcoTosin
    21-Topaz I
    21-Topaz I
    November 13, 2015

    Melvin,

    your request is about Integrity or Windchill?

    Marco
    mlegge1-VisitorAuthor
    1-Visitor
    November 13, 2015

    Integrity

    tketz1-VisitorAnswer
    1-Visitor
    December 1, 2015

    Hi,

    this is not possible from Queries (i think there are many RFC for that business case).

    You cann get the Information, using your query and create a report with the backward relationships (parent).

    16-Pearl
    December 1, 2015

    Hello Melvin Legge‌,

    Tobias Ketz‌ answer seems like the most efficient one to me.  Please let us know if it works for you (you can mark his post as correct by clicking on Correct Answer at the bottom of it) or if you need more help.

    Regards,
    Kael