Community Tip - You can change your system assigned username to something more personal in your community settings. X
Thank you.
EPMAsstoredMember Table Return Pointing to EPMDocumentMaster, EPMDocumentMaster Doesn't have the Revision information.
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.
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?
Using SQL Script to get information.
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.