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");