Sometimes the user has a parent and child record with the IDs P1 & C1. Initially both P1 and C1 as CONFIRMED records.

Now modified the records and saved(SAVE) it. Now both P1 and C1 are in UNCONFIRMED state and need to retrieve P1 CONFIRMED record with C1 CONFIRMED record.

The default SOAP query request will retrieve the parent CONFIRMED and child UNCONFIRMED (If a child has the latest version is UNCONFIRMED) record. So, to get the CONFIRMED child version, please follow the subsequent workaround.
 

Product: TIBCO MASTER DATA MANAGEMENT Version: 9.1.0 or higher OS:ALL

Steps to retrieve Parent and child CONFIRMED Versions:

-Add the below context in the SOAP query request.
====
 <Context>
            <Variable name="GOLDEN_BUNDLE" type="boolean">true</Variable>
 </Context>
====

-Enable/set the below property in the configvalues.xml file as "true".

com.tibco.mdm.ui.record.goldenview 
         
-Restart the MDM server and after that hit the SOAP query request, you will get the PARENT and CHILD CONFIRMED versions in the response.

For a reference, please check the attached SQAP QUERY REQUEST XML file.
         

Retrieving CONFIRMED parent record with CONFIRMED child records using SOAP.