Skip to main content
R
Rocky1-Visitor
1-Visitor
November 22, 2017
Question

How to get Child Version & Iteration for a given Assembly through SQL

  • November 22, 2017
  • 1 reply
  • 3428 views

Hi,

 

I am new to Windchill & trying to find out Child Version & Iteration information for the given Parent assembly through SQL. EPMMemberLink IDA3A5 points to IDA2A2 of EPMDocument which is Parent information. Since i have EPMDocument IDA2A2, i can easily get latest version & iteration of a Parent. However, for Child, EPMMemberLink stores EPMDocumentMaster IDA2A2 in IDA3B5, if my child Part has multiple version & iteration then quering EPMDocument based on IDA3MasterReference will fetch multiple records of different versions & iterations for a given component. I am stuck & not able to find a way to get child version & iteration information.

1 reply

R
RandyJones20-Turquoise
20-Turquoise
November 22, 2017
@Rocky wrote:

Hi,

 

I am new to Windchill & trying to find out Child Version & Iteration information for the given Parent assembly through SQL. EPMMemberLink IDA3A5 points to IDA2A2 of EPMDocument which is Parent information. Since i have EPMDocument IDA2A2, i can easily get latest version & iteration of a Parent. However, for Child, EPMMemberLink stores EPMDocumentMaster IDA2A2 in IDA3B5, if my child Part has multiple version & iteration then quering EPMDocument based on IDA3MasterReference will fetch multiple records of different versions & iterations for a given component. I am stuck & not able to find a way to get child version & iteration information.

In the epmdocument table there is EPMAsStoredConfig ida2a2. This is in column ida3c10. You use this and look for rows in the EpmAsStoredMember table in which it's ida3a5 column equals epmdocument.ida3c10. The EpmAsStoredMember has the EPMDocument ida2a2 in it.

R
Rocky1-VisitorAuthor
1-Visitor
November 23, 2017
Hi Randy,
 
Thanks for your reply. But from EPMMemberlink table we get Ida2a2 of document master which gives multiple version & iteration when queried in epmdocument against ida3masterreference. Now which is the child version & iteration used for the given parent is what we are not able to find.
 
Can you provide a sample sql code joining epmmemberlink table with others to find the child version & iteration?
 
Thanks & Regards,
Rocky
B
bkontham12-Amethyst
12-Amethyst
November 27, 2017

Hi Rocky,

 

I'm not sure about SQL queries, but you can get child componets for a given Assembly by using a Query Builder Report. Refer the following article.

 

https://www.ptc.com/en/support/article?n=CS72503 

 

Thanks,

Bhagirath

Terms & ConditionsAccessibility statement