Skip to main content
1-Visitor
March 28, 2022
Solved

WTParts without WTDocuments in Query Builder

  • March 28, 2022
  • 3 replies
  • 1780 views

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!

Best answer by MarcoTosin

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

 

3 replies

MarcoTosin
21-Topaz I
March 28, 2022

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
1-Visitor
April 1, 2022

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?

22-Sapphire I
April 1, 2022

Please see attached. Appears to provide what is requested.