Hi,
I have a table with data in the following format:
ID | col1 | col2 | col3
------------------------
01 | abc | def | ghi
-----------------------
02 | jkl | mno | pqr
-----------------------
I need to send the above data to a webservice in the below format:
<table_root>
<table>
<ID>01</ID>
<col1>abc</col1>
<col2>def</col2>
<col3>ghi</col3>
</table>
<table>
<ID>02</ID>
<col1>jkl</col1>
<col2>mno</col2>
<col3>pqr</col3>
</table>
</table_root>
For this, I have tried to build an NRDM query which looks something like this:
Query
-TABLE_ROOT
--TABLE
---ID
---COL1
---COL2
---COL3
This is giving me the correct result, but the table is apparently getting joined with itself and performing a cartesian product which is taking a lot of time. I should probably not be leaving the WHERE condition blank, but I’m not exactly sure what I should be putting here.
Can someone pelase help me resolve this?
graghu1986 (BOB member since 2016-10-03)