topic Re: Full Load Pass thru filter in Qlik Replicate

Full Load Pass thru filter

fj40wdh — Thu, 06 Mar 2025 15:22:17 GMT

What is the correct format for the full load pass thru filter? I have tried --FILTER: 1=1) ORDER BY COL1, COL2 -- but that results in a parenthesis after the order by ... WHERE (1=1) ORDER BY COL1, COL2) which is in correct syntax. I've tried several different syntaxes hoping to find the magic key, but nothing works.

Using Oracle as the source and Replicate version May 2024 (2024.5.0.511) on Linux

Re: Full Load Pass thru filter

Dana_Baldwin — Thu, 06 Mar 2025 15:42:30 GMT

Hi @fj40wdh

You should be able to use the exact same where clause conditions as if you query the source directly - just leave out the keyword "where". What error / issue do you get when you try the correct syntax you mentioned above?

FYI, we have a couple knowledge articles on this general topic in case you haven't seen them:

Filter for last 90 days of data in Qlik Replicate - Qlik Community - 1880761

Filter for last 90 days of data in Qlik Replicate ... - Qlik Community - 1980009

Thanks,

Dana

Re: Full Load Pass thru filter

fj40wdh — Thu, 06 Mar 2025 15:49:33 GMT

so I use this syntax

1=1) ORDER BY col1, col2,col3, col4, col5, col6

and I get

...WHERE (1=1) ORDER BY col1, col2,col3, col4, col5, col6)

which is OK EXCEPT the ending parenthesis ^

Re: Full Load Pass thru filter

fj40wdh — Thu, 06 Mar 2025 18:28:45 GMT

fixed it like this

1=1) ORDER BY ( CASE when 1=1 THEN 'col1,col2,col3,col4' END

Is there a way to get rid of the parenthesis ?

Re: Full Load Pass thru filter

Dana_Baldwin — Thu, 06 Mar 2025 19:08:53 GMT

It has to be in a format the source will accept - I haven't seen a case where it added the parentheses for you...

Re: Full Load Pass thru filter

fj40wdh — Thu, 06 Mar 2025 19:16:23 GMT

Qlik adds Where ( )

1=1) ORDER BY ( CASE when 1=1 THEN 'col1,col2' END

ends up

Where (1=1) ORDER BY ( CASE when 1=1 THEN 'col1,col2' END )