Extra Suppression Clause
This feature allows you to prevent sends to a configurable set of email
addresses by specifying an SQL condition. The condition should evaluate to a
PostgreSQL boolean value:
TRUE if the subscriber should be not emailed
FALSE if the subscriber should be emailed.
This SQL condition will be included in the WHERE clause of a larger SQL query.
This feature is available to on-premise customers only. Both on-premise and cloud customers have the option of using Suppression Lists, which provide an alternative method of suppressing sends to email addresses. Suppression Lists may be configured via GreenArrow’s web interface or API.
Th Extra Suppression Clause is a server-wide setting which is controlled by
Note that this file does not exist by default. It should be created when
enabling this feature and may be deleted when you no longer wish to use this
The following strings will be replaced if found in the configuration file:
The Organization ID for which the subscriber is being considered.
The name of the PostgreSQL table in which this mailing list’s subscribers are contained.
Here is an example condition:
EXISTS ( SELECT 1 FROM zz_suppressed_inactive_emails WHERE organization_id = %%ORGANIZATION_ID%% AND email = LOWER(%%SUBSCRIBERS_TABLE%%.email) )
Here’s the SQL to create the example table being queried above. The table would be created and populated while logged into GreenArrow’s PostgreSQL database:
CREATE TABLE zz_suppressed_inactive_emails ( organization_id int, email text );
In the above example, the
zz_suppressed_inactive_emails table contains
To determine the number of subscribers that both were suppressed using this
system and would not have otherwise been suppressed by another mechanism,
Enter dispatch ID(s) that you wish to check, one per line and the program
will return the number of suppressed subscribers in that dispatch ID’s
A campaign’s dispatch ID is the final number that appears in a URL when you’re viewing a camaign’s stats. For example, the dispatch ID for
In the example below, data is collected for dispatch IDs
# /var/hvmail/studio/script/check-special-suppression-counts Ready to accept dispatch IDs. 1 291 64 99182
When you’re finished, press Ctrl-C to exit.