I am working on a report that captures the Life Cycle Template of an EPM Document via the Query Builder, but I am struggling to add the correct "Join"/link between the two object Types.
From your knowledge of how the database is built do you know how I could create the link? From what I understand, the Query Builder accesses the database tables to retrieve the data, for example, to create a link between EPM Documents and WTParts the "Join" in the Query Builder is:
From Reference To
EPMBuildRule Role AObject Ref EPM Document
EPMBuildRule Role BObject Ref WTPart
EPM Document: wt.epm.EPMDocument
A similar method is used to join CAD Models with CAD Drawings, using EPMDescribe Link (wt.epm.structure.EPMDescribeLink) and EPM Document Master.
I have tried several variations of the above to try and create a correct link between EPM Document and Life Cycle Template (wt.lifecycle.LifeCycleTemplate) but I cannot get any results.
I forgot to mention that I am interested in the iteration of the life cycle template. I need to find out which EPMDocument is using which iteration of a given life cycle template
I have created report in Windchill 10.2. so not sure if you are able to import it on Windchill 9.1.PFA attached screenshot of join.