Filter condition in full load pass thru in qlik replicate

[chandraprakash_j_volvo]

I want to limit the number of records during full load.

So in full load pass thru I am using filter condition for "ID" column.

But it gives error with ORA-00908: missing NULL keyword 

What mistake i am doing here?

[chandraprakash_j_volvo]

Even I have tried with

$ID = 'abc'. it gave ORA-00911: invalid character  as an error

[john_wang · Accepted solution]

Hello @chandraprakash_j_volvo ,

Thanks for reaching out to Qlik Community!

Would you try the express: ID = 'abc' in "Fullload Passthrough Filter"?

If you still face any error, please turn on SOURCE_UNLOAD to Verbose and check the SQL Statements in task log file to understand why the expression failed.

Hope this helps.

Regards,

John.