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

QuerySpec joining both WTPart and WTPartMaster

  • September 1, 2025
  • 3 replies
  • 257 views

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?

Best answer by HelesicPetr

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

3 replies

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
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. 

HelesicPetr
22-Sapphire II
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

PetrH
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,

Catalina | PTC Community Moderator
Terms & ConditionsCookie settingsAccessibility statement