Unable to fetch delta batch using tSAPTableinput component

[KarthikGs]

Hi Team,

I'm trying to fetch new batch of data using filter condition in tSAPTableinput component by using the filter option ( attached in the screenshot).

The source column DAT is of format (yyyy.MM.dd) and the context variable is also of same column.

I am using 2023.02.13(context.last_loaded) as the delta value. While running the job the filter is picking up wrong set of records which contain data of Jan month as well.

Scenario 1 : when i'm using context variable as string, it fetching more data than expected.

Scenario 2: when i'm using context variable as date, no data is being fetched.

Can someone, throw light on where am i doing it wrong?

[Anonymous]

Hello,

Note that the column value must be surrounded by single quotes and there must be a blank space before and after the equals sign (=) in the filter expression.

Here is the component reference about:

https://help.talend.com/r/en-US/8.0/sap/tsaptableinput-standard-properties

And please try to use yyyyMMdd date format without any "." and could you please post your context variable setting screenshot here?

Best regards

Sabrina