Hi experts,
I've built my query statement as per this help page.
The resulting xml is the following.
<?xml version="1.0" encoding="UTF-8"?> <ns1:root xmlns:ns1="http://namespace"> <stmt> <table action="SQL_DML"> <access>select [col1] as name1, 'A' as type, [.. sql statement ..] where date = '$Date$'</access> <key> <Date>2018-01-21</Date> </key> </table> </stmt> </ns1:root>
The placeholders replacement works fine (I used '$<keyField>$' in the mapping as suggested in the help page).
But the jdbc receiver adapter removes my quotes. I need to keep them otherwise the query is not working. How can I do that?
Regards.
Cristian