WTParts without WTDocuments in Query Builder

[WV_10110649]

Hi,

We would like to make a report to get WTParts that are not associated with any WTDocument (WTParts without WTDocumets). We want to do something similar to a Left Join or Inner Join but with Query Builder.

Is there any possibility to do this kind of Joins in Query Builder or Are there any examples of Sub selects that try to replicate this?

Thank you!

[Marco_Tosin · Accepted solution]

You can look at this article

Query Builder Report to get the list of parts which does not have any related document

Take a look also at this brand new page from Technical Support

Windchill Reporting Resource

[WV_10110649]

Hi! The article has been useful but I have a concern. I'd like to get more information from the WTPart; but when I add more fields on the Select Tab, It does not filter by WTParts without devices, It shows everything 😞 any suggestion?

[MikeLockwood]

Please see attached. Appears to provide what is requested.