Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
How-to-filter-using-sql-in-source-lookup
... but I do not manage to include SQL for filter conditions.
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.
see: https://community.qlik.com/t5/Qlik-Replicate/Using-LookCapture-in-CDC/td-p/2120033
Hein
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.
see: https://community.qlik.com/t5/Qlik-Replicate/Using-LookCapture-in-CDC/td-p/2120033
Hein
Ok, that's clear, thank you for your responsiveness.
Ole Dufour