SolidWorks PDM BOM, how to get the bom using sql when ShowChildComponentsInBOM_Promote=2

SOLIDWORKS SOLIDWORKS PDM
1

Hello, I’m trying to get the SolidWorks bom of an assembly out of the PDM.
I can do it using a sotred procedure as an example.
But it does not consider when ShowChildComponentsInBOM_Promote=2, the children are not “promoted” to the parent. Someone knows how to do it? Thanks in advance. regards

2

That is a SOLIDWORKS setting? What BOM layout are you using?

3

Hi, you can set it in the CAD. Than you can get it in the result of the SP that the PDM is using for bom. But I need to get the BOM “promoted” that’s not available from API (at least from my knowledge) . I did it with a dedicated SP, but I would like to understand if there is more “robust” and “official”. But from the respoinse, I guess no. Thanks