Windchill9: Require report to display all objects which are related to ResultantPart in Change Task

[pshinde]

I want to generate a Report/querywhich will list all the assemblies/endItems [upto the Root Node] for the Resulting WTParts listed in Change Task. e.g.

Assembly01

+--Part01 +--Part02 Assembly02

+--Part 01

+--Part02 +--Part03 EndItem01 [Product] +--Assembly01 EndItem02 +-Assembly02 Assembly03

+--Assembly01

+--Assembly02

ChangeTask01

+-- Resulting WTPart [Part01]

Now using the query attached If the Parameter given is ChangeTask01

I get results as

Assembly01

Assembly02

Which is perfectly correct. I want results which will list all the assemblies/EndItem [Up to Root Level]. The results should have been

Assembly01

Assembly02

Assembly03 ---[as Assembly01 and Assembly02 uses Part01, which are been used in Assembly03]

EndItem01 ------ [as Assembly01 uses Part01, which is been used in EndItem01]

EndItem02 ------ [as Assembly02 uses Part01, which is been used in EndItem02]

How to achieve this [recursive calling] usingReport Manager or any other way?

Didanyone had the requirementon similar lines ?

Sharing the solution/approach would assist

Regards,

Pradeep Shinde

E-mail: -