Skip to main content
1-Visitor
Mar 28, 2022 4:10 PM UTC
Solved

WTParts without WTDocuments in Query Builder

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!

MarcoTosin
21-Topaz II
Mar 28, 2022 4:24 PM UTC

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

 

Marco

3 replies

MarcoTosin
21-Topaz II
Mar 28, 2022 4:24 PM UTC

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

 

Translate
Marco
1-Visitor
Apr 1, 2022 3:18 PM UTC

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?

Translate
22-Sapphire I
Apr 1, 2022 4:08 PM UTC

Please see attached. Appears to provide what is requested.

Translate