Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ole_Dufour
Contributor III
Contributor III

Use Sql in Record Selection Condition

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

Ole_Dufour_0-1695731145884.png

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. 

 

Labels (1)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist III
Specialist III

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

View solution in original post

2 Replies
Heinvandenheuvel
Specialist III
Specialist III

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

Ole_Dufour
Contributor III
Contributor III
Author

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