topic Re: sql dynamic query with multiple conditions in tJavaFlex in Talend Studio

sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 09:42:18 GMT

Hello community !

As shown in the attached photo, I have a sql query in a tJavaFlex and I want to put more conditions in the where

(like row1.code I want to put other conditions: row1.name & row1.adress)

Do i have to loop it in the main code or try other solution ?

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:10:29 GMT

Hi,

The picture is missing in the post. Could you please add them?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:11:55 GMT

Done

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:15:16 GMT

Hi,

You can do like what is currently in the picture. Are you facing any issue here?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:20:21 GMT

Hi,

I want to add in the main code like : '%" +row1.code+"%'"; I want to add something like this for row1.name & row1.address

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:48:24 GMT

Hi,

You can add as many conditions to the Query variable by keep on joining multiple variables and strings. I am not understanding the issue you are facing in it. It will be just one more "and" condition to existing query, right?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 10:53:25 GMT

Hi,

Yes.

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Mon, 18 Mar 2019 11:53:18 GMT

@khbou

I would say your current plan is sufficient in this case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Tue, 19 Mar 2019 10:06:48 GMT

@khbou

I hope you do not have any outstanding queries for this post. Could you please mark it as resolved so that other Talend members can use it for future reference?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: sql dynamic query with multiple conditions in tJavaFlex

Anonymous — Wed, 27 Mar 2019 16:40:14 GMT

I have an error with this code

11.PNG
22.PNG