context variable doesn't show in tmap component in Talend 7.2

[Anonymous]

I have a issue to set up context variables in tmap component, screen shot as below, it will be much appreciate if someone can help.

[Anonymous]

Hi
You are saying 'context variable does not show on tMap', however, you show a screenshot of tDBInput component, what is the issue?

Regards
Shong

[Anonymous]

thank you for response,

 I make other screen shot to show my question.

[Anonymous]

as you see second screen shot, what I want is to use context.schema to replace the part I scratched, it mean to use context as variable to make sql flexible.  so my job can connect to different database.

[Anonymous]

Have you clicked the 'Guess query' button?

[Anonymous]

yes, I did. but no luck.
by the way, this issue doesn't happen in version 7.1

thanks

[tnewbie]

I guess you are inserting the context name within quotes which should be out of the quotes for the system to understand that it needs to be substituted with variable values...if you take care of the ones

marked in red your issue should be solved

[Anonymous]

thank you for response,

I am able to insert context schema as variable in quote as you mention manually for sure, but it is not what I want,

what I want is to let Talend studio generate this quote automatically, which version 7.1 does. 

so it is very useful when you run same job against different database, test, product db e,g.