Error when passing global map parameter in sql query

[Anonymous]

Hi

I have created a job like

DBInput---> row1(main)--->tFlowIterate-->DBinput

I wanted to use the result of first query as input parameter to the second query.

I posted the schema of first schema column and the second schema query is like

SELECT * FROM myTable where COUNT(1) = " + ((Integer)globalMap.get("row1.count_group")) + ");

Getting error as:  Error near row1

Can anyone help me out what am I missing?

Thanks in advance,

Meghana. 

[fdenis]

"SELECT * FROM myTable where COUNT(1) = " + (String)((Integer)globalMap.get("row1.count_group")) + ")"
with " and without ;

[TRF]

Should be like this:
"SELECT * FROM myTable where COUNT(1) = " + ((Integer)globalMap.get("row1.count_group"));

Double quote at the beginning, not ) at the end

[Anonymous]

It's not working, still I am getting same error.

select * from "employee_detail" where age = '"+((String)globalMap.get("row1.system_user_id"))+"' 

The above query I used for another job and it worked fine. 

But, I am getting error for this job as I mentioned before.

Thanks,

Meghana.

[Anonymous]

I am still getting error

[fdenis]

can you show us your error message.

[Anonymous]

Here it is

Screen Shot 2018-09-03 at 6.48.54 PM.png

[fdenis]

and your component configuration!

[Anonymous]

Configuration of which component first db or second db

[fdenis]

the one who is red or booth!