Skip to main content
@_164713-Aquamarine
13-Aquamarine
Aug 28, 2024 3:38 AM UTC
Question

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

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 

1 reply

HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
Aug 28, 2024 6:30 AM UTC

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

Translate
Terms & ConditionsAccessibility statement