QuerySpec joining both WTPart and WTPartMaster

[VM_13704617]

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?

[avillanueva]

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]

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

[Catalina]

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,