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

[mlegge]

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

[Marco_Tosin]

Melvin,

your request is about Integrity or Windchill?

[mlegge]

Integrity

[tketz · Accepted solution]

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

[KaelLizak]

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