Version: Windchill 12.1

Use Case: We are trying to Extract Windchill As-stored BOM Information from Windchill DB, We are not finding the child information instead of same parent information is repeated equals to child rows.

Please check attachment for the query used.

SELECT
    parent_dm.CADName AS Parent_CADName,
	parent_dm.idA2A2 AS Parent_MasterID,
    parent_doc.versionIdA2versionInfo AS Parent_Version,
    parent_doc.iterationIdA2iterationInfo AS Parent_Iteration,
	parent_doc.idA2A2 AS Parent_Doc_ID,
    child_dm.CADName AS Child_CADName,
	child_dm.idA2A2 AS Child_MasterID,
    child_doc.versionIdA2versionInfo AS Child_Version,
    child_doc.iterationIdA2iterationInfo AS Child_Iteration,
	child_doc.idA2A2 AS Child_doc_ID	
FROM pdmlink.EPMDocument parent_doc
JOIN pdmlink.EPMDocumentMaster parent_dm 
    ON parent_doc.idA3masterReference = parent_dm.idA2A2
JOIN pdmlink.EPMMemberLink ml 
    ON ml.idA3A5 = parent_doc.idA2A2
JOIN pdmlink.EPMAsStoredMember asstored 
	ON asstored.idA3B5 = ml.idA3A5	
JOIN pdmlink.EPMAsStoredConfig as config
	ON config.idA2A2 = asstored.idA3A5 
JOIN pdmlink.EPMDocument child_doc 
    ON asstored.idA3B5 = child_doc.idA2A2	
JOIN pdmlink.EPMDocumentMaster child_dm
    ON child_doc.idA3masterReference = child_dm.idA2A2
WHERE parent_dm.CADName = '13_oct_assy_1.asm'
AND parent_doc.versionIdA2versionInfo = 'P1'
AND parent_doc.iterationIdA2iterationInfo = '1'
ORDER BY parent_dm.CADName, child_dm.CADName;