Skip to main content
D
17-Peridot
Dobi17-Peridot
17-Peridot
May 8, 2025
Solved

Windchill report for reworks within tasks AND change notices

  • May 8, 2025
  • 1 reply
  • 1094 views

Version: Windchill 13.0

 

Use Case: In our change notice flow I have options to "Rework" at the ECN workflow level and also within the change activities as part of the ECN. I want to get a report to count the reworks overall per ECN but seem to be able to get either just the activities, or just the ECN reworks and not both.


Description:

There are couple of really useful references on Windchill ECN reporting:

CS48714 - How to use Query Builder to generate a report to show Change Notice related information in Windchill PDMLink

CS336467 - How to link work items of an upstream change object to downstream ones (CR to CN, etc.)

CS153902 - Data model

 

In our ECN flow there are rework routes within the ECN workflow and also within the Change Activity workflows:

Dobi_1-1746715950098.png

 

All of the above work but they end up only showing the reworks within the ECN workflow and don't display the change activity reworks. 

 

If I go this route with looking at assigned activities, I get the workflow processes for both the ECN and the activities, but as soon as I add the change notice table, the activity data drops off. 

Dobi_4-1746716166462.png

 

With change notice added:

Dobi_3-1746716139890.png

 

What am I missing to consolidate reworks within an ECN that counts both the ECN reworks AND the task reworks within it? 

 

Best answer by Marco Tosin

This is one of the most comprehensive reports I have prepared for change-related objects.

 

Marco_Tosin_0-1747118848516.png

 

 

You will find linked to it. Change Requests (ECRs), Change Tasks, Change Notice (ECNs), workflow processes, assignees, etc... (I apologize for the Italian of some of the entries but it should be fairly easy to trace back to the relevant name in English) and, as you can see, there are many outer joins.

 

You can retrieve the reassignments from the work item table.

 

 

 

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
May 8, 2025

I think you need to put an outer join to the link to the ECNs table, so that the report extracts data even if the assigned activity is NOT linked to this table.

 

 

Marco
D
17-Peridot
Dobi17-PeridotAuthor
17-Peridot
May 12, 2025

Once I add that outer join I get the change tasks with their reworks and the ECNs with theirs... but there's no relationship between the ECNs and Tasks. In other words, I can get the task number for an ECN and then look for the number of times that task shows up. That's a secondary operation though. 

 

What's the best way to get the ECN to show both the number of reworks within it's flow AND to tie in the associated tasks as part of it's implementation plan for the total sum of reworks? 

 

Dobi_0-1747086877723.png

 

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAnswer
21-Topaz I
May 13, 2025

This is one of the most comprehensive reports I have prepared for change-related objects.

 

Marco_Tosin_0-1747118848516.png

 

 

You will find linked to it. Change Requests (ECRs), Change Tasks, Change Notice (ECNs), workflow processes, assignees, etc... (I apologize for the Italian of some of the entries but it should be fairly easy to trace back to the relevant name in English) and, as you can see, there are many outer joins.

 

You can retrieve the reassignments from the work item table.

 

 

 

Marco
    Terms & ConditionsCookie settingsAccessibility statement