Skip to main content
Rocky1-Visitor
1-Visitor
Nov 22, 2017 10:43 PM UTC
Question

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

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.

6 replies

RandyJones20-Turquoise
20-Turquoise
Nov 22, 2017 11:24 PM UTC
@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.

Translate
Rocky1-VisitorAuthor
1-Visitor
Nov 23, 2017 2:33 AM UTC
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
Translate
bkontham12-Amethyst
12-Amethyst
Nov 27, 2017 5:38 PM UTC

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

Translate
Terms & ConditionsAccessibility statement