Full Load Pass thru filter

[fj40wdh]

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

[Dana_Baldwin]

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

[fj40wdh]

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                      ^

[fj40wdh · Accepted solution]

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 ?

[Dana_Baldwin]

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

[fj40wdh]

Qlik adds  Where (  )

So 

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 )