Skip to main content
Nov 13, 2015 2:44 PM UTC
Solved

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

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

    tketzAnswer
    Dec 1, 2015 10:05 AM UTC

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

    4 replies

    1-Visitor
    Nov 13, 2015 3:13 PM UTC

    Melvin,

    your request is about Integrity or Windchill?

    mleggeAuthor
    Nov 13, 2015 3:14 PM UTC

    Integrity

    tketzAnswer
    Dec 1, 2015 10:05 AM UTC

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

    Dec 1, 2015 2:27 PM UTC

    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