Find Lifecycles assign to an object

Forum|Forum|1 year ago
April 7, 2025
2 replies
744 views

Version: Windchill 13.0

Use Case: Determine the lifecycle associated with an object in Windchill.

Description:

We have multiple Lifecycles from the original administrator and I'm trying to find which ones have been used by objects so I can reduce the number of old lifecycles.

Is there a method to do a search in Windchill by Lifecycle to return which objects it is associated with?

My second possible search would be in the Oracle tables but I don't really have any idea where to start with them in SQLDeveloper. I do have a test system that I can play with so all my production data is safe.

Bus_System Administration

S

Shreyas_Atre

12-Amethyst

try with below SQL
SELECT
pm.WTPARTNUMBER AS "Part Number",
ltm.name AS "Lifecycle Name",
lt.ITERATIONIDA2ITERATIONINFO AS "Lifecycle Version"
FROM
WTPart p
JOIN wtpartMaster pm ON pm.ida2a2 = p.IDA3MASTERREFERENCE
JOIN LifeCycleTemplate lt ON lt.ida2a2 = p.ida3a2state
JOIN LifeCycleTemplateMaster ltm ON ltm.ida2a2 = lt.IDA3MASTERREFERENCE;

also you can create QML report to get the details of lifecycle assigned to object. attached is sample report for WTPART.

Hope this helps.

Thanks

1_PartLifecycle.xml