topic Use Sql in Record Selection Condition in Qlik Replicate

Use Sql in Record Selection Condition

Ole_Dufour — Tue, 26 Sep 2023 12:30:34 GMT

I'm wondering if it possible to use sql in the filter of a table (Record Selection Condition)
See below

I know that it is possible to include Sql in a source lookup :

... but I do not manage to include SQL for filter conditions.

Heinvandenheuvel — Tue, 26 Sep 2023 14:13:54 GMT

You can only use native source sql in the passthru (fullload) filtering

For generic (cdc) filtering base on source data you must use source_lookup in the RSE.

Hein

Ole_Dufour — Tue, 26 Sep 2023 14:23:37 GMT

Ok, that's clear, thank you for your responsiveness.
Ole Dufour