Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Custom IN sql query in JDBC lookup

I want to use custom sql IN query in the jdbc lookup stage.

concatedList = List of String for example , ["1","2","3"]

query - SELECT * FROM tableName WHERE id IN (${record:value('/concatedList')});

But this is getting converted as :

SELECT * FROM tableName WHERE id IN (Field[STRING:1], Field[STRING:2], Field[STRING:3])

Expected : SELECT * FROM tableName WHERE id IN ("1","2","3");

Custom IN sql query in JDBC lookup

I want to use custom sql IN query in the jdbc lookup stage.

concatedList = List of String for example , ["1","2","3"]

query - SELECT * FROM tableName WHERE id IN (${record:value('/concatedList')});

But this is getting converted as :

SELECT * FROM tableName WHERE id IN (Field[STRING:1], Field[STRING:2], Field[STRING:3]) Field[STRING:3])

Expected :

SELECT * FROM tableName WHERE id IN ("1","2","3");