topic Re: How could use context variable with OR clause in sql in Talend Studio

How could use context variable with OR clause in sql

kakooo16 — Mon, 14 Jun 2021 08:37:57 GMT

Hello ,

I have query

Select

from

table_name

Where

(

900

)

AND

( (

'F01'

)

(

'CIP'

)

(

'T01'

)

(

'U01'

)

(

'L01'

))

I want to contextialize my variable x and y .

I know that my query would be

Select

from

table_name

Where

(context.

900

)

AND

( (context. y=

'F01'

)

(context.y=

'CIP'

)

(context.y=

'T01'

)

(context.y=

'U01'

)

(context.y=

'L01'

))

How could i put different values into the same context variable X ?

Re: How could use context variable with OR clause in sql

gjeremy1617088143 — Mon, 14 Jun 2021 08:46:55 GMT

Hi ,

first :

AND

( (context. y=

'F01'

)

(context.y=

'CIP'

)

(context.y=

'T01'

)

(context.y=

'U01'

)

(context.y=

'L01'

))

--> AND context.y in ('F01','CIP','T01','U01','L01' )

second :

If you want multiple values you can separate your values by a delimiter in you context variable ex : "900;800;700;600"

then you use a tnormalize with ; as separator on this value,

then you iterate with a tflowtoiterate and you use the globalMap value of the field of the tflowtoiterate in your query.

Send me Love and Kudos

Re: How could use context variable with OR clause in sql

Anonymous — Tue, 15 Jun 2021 02:37:52 GMT

The query looks like:

"Select x,y,z from tablename where x=“+context.x+" and y in "+context.y

before executing the query, you can set the value of context variable on tJava/tJavaFlex component, eg:

...tJava--onComponentOK--tMysqlInput--main--...

on tJava:

context.x="900";

context.y="('T01','U01','D01')";

Regards

Shong