Skip to main content
M
Muthukumaran1-Visitor
1-Visitor
August 5, 2024
Question

Asstored BOM Extraction from Database

  • August 5, 2024
  • 2 replies
  • 1161 views
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.

    2 replies

    Fadel
    Fadel23-Emerald I
    23-Emerald I
    August 5, 2024

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

    Buiꓘa
    M
    Muthukumaran1-VisitorAuthor
    1-Visitor
    August 5, 2024

    Thank you.

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

    V
    vnamboodheriCommunity Manager
    Community Moderator
    August 12, 2024

    Hello @mb_01_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
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    August 5, 2024

    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?

    M
    Muthukumaran1-VisitorAuthor
    1-Visitor
    August 5, 2024

    Using SQL Script to get information.

    joe_morton
    18-Opal
    joe_morton18-Opal
    18-Opal
    August 5, 2024

    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
    Terms & ConditionsAccessibility statement