topic Re: Passthru filter not working in Qlik Replicate

Passthru filter not working

vabclb — Wed, 19 Mar 2025 20:13:13 GMT

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')

Re: Passthru filter not working

Steve_Nguyen — Wed, 19 Mar 2025 20:22:52 GMT

here are some article that should help :

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

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/2416287

Re: Passthru filter not working

vabclb — Wed, 19 Mar 2025 20:28:13 GMT

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

$last_updated_timestamp >= trunc(CURRENT_DATE - 1)

Re: Passthru filter not working

john_wang — Sun, 23 Mar 2025 14:03:47 GMT

Hi @vabclb ,

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

Regards,

John.

Re: Passthru filter not working

vabclb — Sun, 23 Mar 2025 15:45:01 GMT

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

Re: Passthru filter not working

john_wang — Sun, 23 Mar 2025 23:44:19 GMT

Hi @vabclb ,

Thank you so much for your great support!

Regards,

John.