topic Re: selecting table from mysql based on date condition in Talend Studio

selecting table from mysql based on date condition

BA621858188 — Mon, 25 Jul 2022 16:34:05 GMT

Hi All,

I want to retrieve the data from mysql table based on date 2022-07-24 in dynamic way.

select * from table where loaddate= '2022-07-24'(need to update with dynamic)

what need to use here to go with dynamic way and I dont want to use context need to use in query only.

Thanks

Re: selecting table from mysql based on date condition

Anonymous — Tue, 26 Jul 2022 03:49:19 GMT

Using context variable and update the value of context variable dynamically in the job. eg:

"select * from table where loaddate= '+context.loaddate+"'"

before the subjob starting with tMysqlInput, you can update the value of context variable dynamically on a tJava, eg:

tJava

|onsubjobok

tMysqlInput...

on tJava:

context.loadate=TalendDate.formatDate("yyyy-MM-dd",TalendDate.getCurrentDate());

//TalendDate.getCurrentDate() returns the current date, how/where does the loaddate come from in your case?

Regards

Shong

Re: selecting table from mysql based on date condition

NCrawford1658815487 — Tue, 26 Jul 2022 06:05:47 GMT

I'm having the same problem as the others.

Re: selecting table from mysql based on date condition

BA621858188 — Tue, 26 Jul 2022 06:10:26 GMT

Hi @Shicong Hong

if we want to do at DB component level what we can add like you have mentioned to have context parameter.

Any alternate way other than context param?

Thank you

Re: selecting table from mysql based on date condition

BA621858188 — Tue, 26 Jul 2022 06:10:59 GMT

are you able to do filter in DB itself using dynamic way.

Re: selecting table from mysql based on date condition

Anonymous — Tue, 26 Jul 2022 07:53:19 GMT

what do you mean 'at DB component level? provide the value by user who run the job during the job execution? or load the value from somewhere?

Re: selecting table from mysql based on date condition

BA621858188 — Tue, 26 Jul 2022 08:19:31 GMT

Hi @Shicong Hong

I have tdbinput where I am using mysql conn and below query

select * from table where loaddate='<date>'

I am using hardcode value as of now but wanted to use the date in dynamic way but without using the context value.

Re: selecting table from mysql based on date condition

Anonymous — Wed, 27 Jul 2022 02:04:55 GMT

@Vrushabh Malbari , Maybe I don't understand your requirement well, if you don't use context variable or global variable, how do you pass the value to the query at runtime? Can you explain what is the behavior you expect in dynamic way?