Superseded Part number report

[JHall]

 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

[Marco_Tosin]

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

[JHall]

@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

[Marco_Tosin]

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