Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ole_Dufour
Creator
Creator

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
Creator
Creator
Author

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