Skip to main content
VM_137046178-Gravel
8-Gravel
September 1, 2025
Solved

QuerySpec joining both WTPart and WTPartMaster

I need to find a WTPart/WTPartMaster that matches to specific partNumber, partRevision, View and Organization I provide. How can this be achieved by QuerySpec? Or is there any alternative?

HelesicPetr
HelesicPetrAnswer
22-Sapphire II
September 9, 2025

Hi @VM_13704617 

I usually use joins to link the tables together and then I put the input criteria

 

here is an example how to use joins in the QuerySpec

Query spec for multiple objects

 

In your case you have to join following tables, WTPart, WTPartMaster, ViewReference, 

PetrH

View in thread

3 replies

avillanueva
avillanueva23-Emerald II
23-Emerald II
September 2, 2025

If you have a reference to the WTPart or WTPartMaster, you can use the VersionControlHelper service to get all versions then loop through those. A simple Queryspec would only need to get a part by number. 

Translate
HelesicPetr
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
September 9, 2025

Hi @VM_13704617 

I usually use joins to link the tables together and then I put the input criteria

 

here is an example how to use joins in the QuerySpec

Query spec for multiple objects

 

In your case you have to join following tables, WTPart, WTPartMaster, ViewReference, 

PetrH

Translate
Catalina
CatalinaCommunity Manager
Community Moderator
September 12, 2025

Hi @VM_13704617,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.


Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

Translate
Catalina | PTC Community Moderator
Terms & ConditionsAccessibility statement