topic Re: Add a filter in tOracleInput query in Talend Studio

Add a filter in tOracleInput query

Anonymous — Wed, 22 Aug 2018 06:54:51 GMT

Hi everyone, I want to ask you how to add a filter in tOracleInput query. Example : " select * from table1 where name='blabla'" So how to add the syntax "where name='blabla' dynamically ? Thanks for your responses.

Re: Add a filter in tOracleInput query

iamabhishek — Wed, 22 Aug 2018 08:21:09 GMT

The Sql queries in Talend are simply String represented in Java language format. So, to play with them you and build your query dynamically you have to make sure you built a String which will finally represent a legitimate SQL query.

Example :

"select * from table1 where name='blabla'"

Now if you want to have your WHERE clause to be dynamic and make it pass from context variable you could simply use -

"Select * from table1 " + context.whereclause

or if you want to get it from any previous component values

"Select * from table1 " + ((String)globalMap.get("row1.whereclause"))

Tip: Build your SQL query, output it to the console and then test the String you see in your database. If it works there, it will work in your Talend component.

Re: Add a filter in tOracleInput query

fdenis — Wed, 22 Aug 2018 08:23:02 GMT

use context or globalMap variables to store blabla
the use java syntax ("select * from table where name=''" + globalMap.get("blablaVariableName")+ "") to write yours query.
regards

Re: Add a filter in tOracleInput query

Anonymous — Wed, 22 Aug 2018 09:24:19 GMT

Thank you guys.

Re: Add a filter in tOracleInput query

fdenis — Wed, 22 Aug 2018 10:21:38 GMT

hi,

One day you are going to help me or someone!

you can use kudos to thank.
you can Tag "solved" to help on same problems.

Regards,