In SQL List¶

This condition, located in the Miscellaneous category, will return the results of a special SQL query. The SQL script must be in Special Content > SQL Scripts and must return only a list of PeopleIds. Set the Comparison to Equal and the Codes to True, then enter the name of the script in the Sql Script field.

If you set the Comparison/Codes to Equal/False (or to NotEqual/True), any person in the database that is not found in the SQL query results will be returned.