topic Re: QuerySpec joining both WTPart and WTPartMaster in Windchill Customization

QuerySpec joining both WTPart and WTPartMaster

VM_13704617 — Mon, 01 Sep 2025 07:24:19 GMT

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?

Re: QuerySpec joining both WTPart and WTPartMaster

avillanueva — Tue, 02 Sep 2025 19:31:16 GMT

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.

Re: QuerySpec joining both WTPart and WTPartMaster

HelesicPetr — Tue, 09 Sep 2025 06:42:15 GMT

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

Re: QuerySpec joining both WTPart and WTPartMaster

Catalina — Fri, 12 Sep 2025 14:50:07 GMT

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,