2-Explorer

Question

Superseded Part number report

3 replies
2479 views
Translate All

Greetings all.

I'm a novice Report writer, but I'm giving it a whirl. I've written a small report to return all parts that have been Superseded in Windchill. I can get that, and the State of the WTPart that was the result of the super-session. What I can't seem to collect is the state of the Superseded part? Strange to me that I can't seem to collect both. Every time I add a second lifecycle to the report, I get duplicates and an incorrect result. I've Photoshopped what I'm looking for and attached the QML. Anyone got any ideas? Thanks in Advance.

James Windchill 11.0 M030

Reporting

21-Topaz II

Hi James,

in this document there are a couple of reports that I hope could be helpful for you.

How to create a Query Builder report that reports WTPart Supersession

https://www.ptc.com/en/support/article?n=CS273436

How to create a QML Report to display Supersede History

https://www.ptc.com/en/support/article?n=CS314228

Translate

Marco

Author

2-Explorer

@Marco_Tosin Thanks! I'm looking through those reports, but I'm not seeing yet what I need.

Here is my QML I forgot to attach it.

James 11.0 M030

Translate

1_WTPart-Supersession.zip

21-Topaz II

James,

we don't use superseded parts so I can't look at your report, but I suggest to look at some of BOM reports in the document.

There you can see how to use many times the same object type in a report (for example Parent and Child WTPart in a BOM).

In that way you can extract the state from each of the types

Translate

Marco