Six Stars

tSAPTableInput component filter option for date value filter

Hi All,

 

I need a immediate help on the below task , we are using SAP as a source and doing an incremental load function using last_run_date from the control run table and passing this date value to context variable and using this context variable in the tSAPTableInput component filter box get the date columns filter based on the last_run_date.

 

But i'm struggling to implement this between operation for create date(ERSDA ) and changed date (LAEDA )columns

currently I'm comparing the last_run_date with LAEDA changed_date using this syntax ("LAEDA >'"+context.Last_Run_Date +"'") and getting some results but I need to perform the between function like below

 

ERSDA BETWEEN LAST_RUN_DATE AND SYSDATE

And LAEDA BETWEEN LAST_RUN_DATE AND SYSDATE

 

what is the syntax for this in tSAPTableinput ? and how can I implement this ?

Thanks in advance.

by

Tamil

 

 

 

5 REPLIES
Six Stars

Re: tSAPTableInput component filter option for date value filter

Hi Talend Team,

Any update on the above syntax ?
Moderator

Re: tSAPTableInput component filter option for date value filter

Hello,

Could you please show us your filter field screenshot in tSAPTableInput component? Which will be helpful for us to understand your question.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: tSAPTableInput component filter option for date value filter

Hi Sabrina,

Please find my attached screenshot for the job tSAPTableInput settings.
[image: Inline image 1]

Thanks
Tamil Mynthan
Six Stars

Re: tSAPTableInput component filter option for date value filter

Hi Sabrina/Talend team,

 

The below is my syntax I'm using to filter the data from the SAP table but its not working perfectly , but when I use the ERSDA >='"+context.Last_Created_Date +"' or LAEDA >='"+context.Last_Modified_Date +"' alone in the filter its working fine, don't know how to pass two context with OR condition in tSAPTableInput component filter box.

 

 is this correct or need to change anything ?

" MTART in ('HALB', 'HIBE', 'ROH', 'WERZ') AND ( ERSDA >='"+context.Last_Created_Date +"' OR LAEDA >='"+context.Last_Modified_Date +"' ) "

Moderator

Re: tSAPTableInput component filter option for date value filter

Hi,

Could you please check your "Code" tab in your job to see if there is any compile error highlighted in red line for your synax?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.