Asstored BOM Extraction from Database

[Muthukumaran]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.1.0

We are working to get the Windchill Asstored BOM From Data Base or API But we are not able to Achieve the information, From the database Asstored BOM We able to get but Child Revision information not available. Please guide us to get the Required Information.

[Fadel]

take a look at https://www.ptc.com/en/support/article/CS163243 

[Muthukumaran]

Thank you.

EPMAsstoredMember Table Return Pointing to EPMDocumentMaster, EPMDocumentMaster Doesn't have the Revision information.

[vnamboodheri]

Hello @mb_10818214,

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.

[avillanueva]

This would be a very complex query, especially if multi-level. Are you sure you want to handle this at the API or SQL level?

[Muthukumaran]

Using SQL Script to get information.

[joe_morton]

This does get quite complex..

Normal query will only get single level BOMS. You will need to run your query recursively if you need multi-level BOMs. 

To get the correct revision of the children objects, you will have to consider your own business rules.

• If the correct revision is always the latest revision, then you would have to add criteria to get latest version. Here is some reference to help: https://www.ptc.com/en/support/article/CS138336?source=search
• If the correct revision is the latest revision at a certain life cycle state, then you would have to develop the corresponding criteria
• Or it could be your business needs some other criteria