Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
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!
Solved! Go to 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
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
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.