Use JSON field in SQL Query

fjblau — Fri, 15 Nov 2024 21:59:03 GMT

I have a field in my json that lists machine names.... I am able to extract that and it gives me the right values. I iterate on that output with

JSON ---Row2---> FlowToIterate -> DBinput - tLogRow

in the dbInput SQL Query I have:

"SELECT inspectionMachineName,

lastPrId

FROM inspectionMachine

where inspectionMachineName = "+(String)globalMap.get(\"row2.DbName\")

But I cannot get it to run and display the data from inspectionMachine table.

Any ideas?

Re: Use JSON field in SQL Query

Anonymous — Mon, 20 Mar 2023 05:02:41 GMT

Before using the global variable in the query, print the value of (String)globalMap.get("row2.DbName") on a tJava to check whether it has the right value.

JSON ---Row2---> FlowToIterate -> tJava

on tJava:

System.out.println((String)globalMap.get("row2.DbName"));

Regards

Shong

topic Use JSON field in SQL Query in Talend Studio

Use JSON field in SQL Query

Re: Use JSON field in SQL Query