Skip to main content
mlegge1-Visitor
1-Visitor
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
    1-Visitor
    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).

    View in thread

    4 replies

    MarcoTosin
    MarcoTosin21-Topaz II
    21-Topaz II
    Nov 13, 2015 3:13 PM UTC

    Melvin,

    your request is about Integrity or Windchill?

    Translate
    Marco
    mlegge1-VisitorAuthor
    1-Visitor
    Nov 13, 2015 3:14 PM UTC

    Integrity

    Translate
    tketz1-VisitorAnswer
    1-Visitor
    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).

    Translate
    KaelLizak16-Pearl
    16-Pearl
    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

    Translate
    Terms & ConditionsAccessibility statement