Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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