Skip to main content
C
cc-21-Visitor
1-Visitor
February 10, 2014
Question

Query Builder 9.1 Link between EPM and Life Cycle template

  • February 10, 2014
  • 4 replies
  • 1115 views

Hello


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

EPMBuildRule: wt.epm.build.EPMBuildRule
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.


Thank you

4 replies

C
cc-21-VisitorAuthor
1-Visitor
February 10, 2014

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

A
Anonymous
February 10, 2014

See attached QML.



Hope this helps !!!


Thanks,
Shreyas

A
Anonymous
February 10, 2014

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.



Thanks,
Shreyas




C
cc-21-VisitorAuthor
1-Visitor
February 10, 2014

Hello



thank you very much for your prompt reply. It works perfectly.


Thanks


Best regards

Terms & ConditionsAccessibility statement