I have a query builder report where I'm entering a child componet number and it's returning a where used list. The issue I'm having is that it returning where used for all revisions / latest iterationforthe child part. It's also returning all revisions of the parents that have usages as well. I'm looking for a way to do a where used on the latest revision / iteration of a child part and return only the latest revision / iteration of the parents. Doesn't anyone have some suggestions on how to get this type of information?
I'm also looking for a multi-level where used report that shows the child, it's parents, grandparents, ..... all the way to the top level. Is this possible?
UTC BIS Compression Technologies Group
Take a look at this document https://community.ptc.com/t5/Windchill-Tips/Resource-for-reporting/td-p/448738
There's a list of report ready to use (search in WTPart section).
This should be the report you're looking for https://www.ptc.com/en/support/article?n=CS72503
Thanks for your reply.
Well, the QML example can´t be loaded because of error
I tried to make a few changes, but they were unsuccessful.
I wrote a comment to the article I reported, asking support if they could attach a valid version for Windchill 11 as well.
You can also try to use my BOM report (I'm on Windchill 11.0 M030), but all columns and comments are in Italian and it is build to work for all my seven views (Design, Manufacturing and 5 different Plants).
On the third attempt, finally, I managed to make the support understand the problem with the report linked to this article.
Now that's usable too.
if you are using query builder than take a look at this document I wrote on PTC Community.
It's very long and collect a lot of things I found here, in the Community and also article from Tech Support.
Hope you can find it useful.