How can we append 2 classes WtChangeOrder2 and WTChangeActivity2 and query for the activity object

[@_1647]

Hi Everyone,

I have Activity number and change notice number  as well and I can use simple query on WTChangeActivity2 to get activity as object but I want to enhance Java query spec so 

How can we append 2 classes  WtChangeOrder2 and WTChangeActivity2 and query for the activity object from specific change notice using number 

[HelesicPetr]

Hi @_1647 

Here is an example how to use joins in query spec. 

https://community.ptc.com/t5/Windchill-Customization/Query-spec-for-multiple-objects/m-p/914578#M985

https://community.ptc.com/t5/Windchill-Customization/QuerySpec-with-specific-WTDocument-soft-type-and-IBA-Value/m-p/877906#M1783

your task is just connect your tables. (objects)

PetrH