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>