|
Data filters apply to the Select, Extract, and Audience processes in Campaign flowcharts. For example, if a database table includes 2000 records but 500 of them are restricted by a data filter, a Select All in Campaign returns only 1500 records.
|
|
Data filters do not apply to raw SQL queries or to custom macros that use raw SQL. For example, if you use Select Customer IDs Using SQL to create a raw SQL query in the Select Process Configuration dialog, any data filters are ignored when you run the query. This behavior is intentional, to provide advanced users with the ability to perform SQL queries without restrictions.
|
|
Raw SQL queries override data filters, so users who perform SQL queries can access records regardless of data filters. If you do not want Campaign users to be able to use raw SQL, you must restrict their permissions.
|
Copyright IBM Corporation 2015. All Rights Reserved.
|