Change Request Overall Completion Status (Windchill Query Builder)

Forum|Forum|2 years ago
April 17, 2024
1 reply
4008 views

I have created a report that shows me the Change request number, Change Notice Number & Change Task Number. It also shows who the tasks are assigned to and the task completion dates.

I want to be able to see the overall completion status of the Change Request, but I only seem to be able to get information up to the point of the reviewer, which is where it changes from the "Change Activity Workflow" to the "Change Notice Workflow".

What do I need to do to see the overall Change request status? It would also help to be able to see the roles for the workflow outside of the "Change Activity Workflow".

Any ideas on how I can achieve this would be greatly appreciated.

Reporting

MarcoTosin

21-Topaz I

Take a look at this discussion

How to list all change objects linked to an object or to any of its dependency obejcts?

Below last evolution of the same report

It should be quite simple to translate table names from Italian to English.

Marco

B

Ben_M

Author

4-Participant

Thanks for the quick reply Marco, that looks like it could be what I need, but I am struggling to find the actual table you have used.

Is there any chance you could expand the titles for I can see the full table names? Or even upload the QML code for the query, which I assume would auto translate them.

These seem to translate to "User PR", "User CR" & "User CN", which I don't think exist.