Passthru filter not working

[vabclb]

I need to add a passthru filter on full load only task to load incremental data everyday. I tried few expressions but nothing is working. The source is aws rds postgres.

$created_at > current_date - interval '1' day

$START_TRAN_DATE >= DateTime('Now', 'LocalTime', '-1 Day')

[Steve_Nguyen]

here are some article that should help :

https://community.qlik.com/t5/Official-Support-Articles/Filter-for-last-90-days-of-data-in-Qlik-Repl...

https://community.qlik.com/t5/Qlik-Replicate/Enable-Passthrough-Filter-on-Replicate/td-p/1993506

https://community.qlik.com/t5/Qlik-Replicate/Pass-thru-filter/td-p/2411372

https://community.qlik.com/t5/Qlik-Replicate/How-do-you-know-if-Passthru-filter-is-working/td-p/2416...

[vabclb]

this is what I got from those links and it didn't work

$last_updated_timestamp >= trunc(CURRENT_DATE - 1)

[john_wang]

Hi @vabclb ,

How about if you remove the prefix "$" unless it's part of the real column name.

Regards,

John.

[vabclb]

I forgot to update this, yeah, I thought that the variable should be called, but on friday, I hardcoded the column name and it worked. thx

[john_wang]

Hi @vabclb ,

Thank you so much for your great support!

Regards,

John.