Summary
XML Publisher Data Group With Two Queries
Content
Hello,
I have the following XML data
<?xml version="1.0" encoding="UTF-8"?><XXTEST_RESULTS> <LIST_G_PROD> <G_PROD> <PRODUCT_NUMBER>P1078</PRODUCT_NUMBER> <PRODUCT_DESC>Test VOLT</PRODUCT_DESC> <PRODUCT_LOCATION>ABC Rack</PRODUCT_LOCATION> </G_PROD> <G_PROD> <PRODUCT_NUMBER>T1273</PRODUCT_NUMBER> <PRODUCT_DESC>ELECT</PRODUCT_DESC> <PRODUCT_LOCATION>XYZ Rack</PRODUCT_LOCATION> </G_PROD> </LIST_G_PROD> <LIST_G_SEG> <G_SEG> <SEGMENT1>Inspection</SEGMENT1> <CREATED_DATE>12-MAY-2017</CREATED_DATE> <UPDATED_DATE>14-MAY-2017</UPDATED_DATE> </G_SEG> <G_SEG> <SEGMENT1>Corrosion</SEGMENT1> <CREATED_DATE>22-MAY-2017</CREATED_DATE> <UPDATED_DATE>24-MAY-2017</UPDATED_DATE> </G_SEG> <G_SEG> <SEGMENT1>Commissioning</SEGMENT1> <CREATED_DATE>01-JUN-2017</CREATED_DATE> <UPDATED_DATE>23-JUN-2017</UPDATED_DATE> </G_SEG> </LIST_G_SEG></XXTEST_RESULTS>
Is it possible to get the RTF output as shown in the enclosed screenshot, I have tried with the repeating group, however, not able to get the desired output.
Appreciate any insight.
My DataTemplate code snippet
<?xml version="1.0" encoding="UTF-8" ?><dataTemplate name ="XXTEST_RESULTS" description="Testing" Version="1.0" ><properties><property name="xml_tag_case" value="upper" /><property name="debug_mode" value="on" /></properties><!--<parameters><parameter name="p_start_date" dataType = "date"></parameter></parameters>--><dataQuery><sqlStatement name="Q1"><![CDATA[ SELECT 'P1078' product_number, 'Test VOLT' product_desc, 'ABC Rack' product_location FROM DUALUNION ALLSELECT 'T1273' product_number, 'ELECT' product_desc, 'XYZ Rack' product_location FROM DUAL]]></sqlStatement><sqlStatement name="Q2"><![CDATA[ SELECT 'P1078' product_number, 'Inspection' segment1, '12-MAY-2017' created_date, '14-MAY-2017' updated_date FROM DUALUNION ALLSELECT 'P1078' product_number, 'Corrosion' segment1, '22-MAY-2017' created_date, '24-MAY-2017' updated_date FROM DUALUNION ALLSELECT 'T1273' product_number, 'Commissioning' segment1, '01-JUN-2017' created_date, '23-JUN-2017' updated_date FROM DUAL]]></sqlStatement></dataQuery><link name="PROD_LINK" parentQuery="Q1" parentColumn="PRODUCT_NUMBER" childQuery="Q2" childColumn="PRODUCT_NUMBER"/><dataStructure><group name="G_PROD" source="Q1"><element name="PRODUCT_NUMBER" value="PRODUCT_NUMBER" /><element name="PRODUCT_DESC" value="PRODUCT_DESC" /><element name="PRODUCT_LOCATION" value="PRODUCT_LOCATION" /></group><group name="G_SEG" source="Q2"><element name="PRODUCT_NUMBER" value="PRODUCT_NUMBER" /><element name="SEGMENT1" value="SEGMENT1" /><element name="CREATED_DATE" value="CREATED_DATE" /><element name="UPDATED_DATE" value="UPDATED_DATE" /></group></dataStructure></dataTemplate>
