cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

WTParts without WTDocuments in Query Builder

WV_10110649
5-Regular Member

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3

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
WV_10110649
5-Regular Member
(To:Marco_Tosin)

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?

Please see attached. Appears to provide what is requested.

Top Tags