Skip to main content
@
@_164713-Aquamarine
13-Aquamarine
August 28, 2024
Question

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

  • August 28, 2024
  • 1 reply
  • 489 views

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
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
August 28, 2024

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

Terms & ConditionsCookie settingsAccessibility statement