Use JSON field in SQL Query

[fjblau]

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?

[Anonymous]

Hi

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