Five Stars

Using context variable in postgresql statement

I have created a context variable and i am trying to use it in postgresql input 
In where clause I 
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px '.SF NS Text'} span.s1 {color: #4237b0} span.s2 {color: #c13500}
where \"dwh01\".\"stg01\".\"table_name\".\"load_ts\"'" + TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", context.load_ts) + "'
It is not able to read my where statement. 
Similar statement in mysql was working fine. 
Is there a different way to use context variable in postresql ? 
2 REPLIES
One Star

Re: Using context variable in postgresql statement

Hi,
Is it the complete where clause?
Do you have a compile error or a runtime error? Which one?
Five Stars

Re: Using context variable in postgresql statement

I have updated the post with the real where clause.
There is no error. 
It seems that it does not filter by the context variable.
I tested the context variable with tjava output and context variable is working fine.