How to filter by date in the tdbinput

[Anonymous]

Hi!

I'm with TOS for Big Data and I want my tdbinput to be filtered in a variable way, taking into account these two dates

• Last_date_update: it is a variable date that takes into account the last time an extraction was made in my system.
• Sysdate

How can I filter directly in tdbinput to only use the data between those two dates?

Thanks!

Regards

[Anonymous]

Hi,

    The most easy way is to use context variables. Please assign the values to these variables and assign these variables as parameters in your tDBInput. For example, please refer below link.

https://community.talend.com/t5/Design-and-Development/resolved-How-to-use-context-variables-in-Quer...

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 🙂