sql dynamic query with multiple conditions in tJavaFlex

[Anonymous]

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 ?

[Anonymous]

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 🙂

[Anonymous]

Done

[Anonymous]

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 🙂

[Anonymous]

Hi,

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

[Anonymous]

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 🙂

[Anonymous]

Hi, 

Yes.

[Anonymous]

@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 🙂

[Anonymous]

@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 🙂

[Anonymous]

I have an error with this code 

11.PNG
22.PNG