What is a Subset (Group) ?

A subset is a group inside a single list. The subset feature of the program could be used to spilt a list in multiple virtual lists.
Sample: a list of customers contains customers from all over the world, but you want to send the message only to customers from the U.S. The country field inside the database will be used to filter the recipients, so that MailList Controller send the newsletter only to recipients from the selected country.

Send a List Message to a Subset

Create the message and click on "Send" in the editor. Now the send dialog opens.
Select the option "Send Message to a Subset" and select an existing subset or create a new subset.
Click on "List Query Builder" to define a subset or change an existing subset.

Subsets – Managed List

MailList Controller lets you define 2 filters, which will be used together. Setup the "Fieldname" to "<<n/a>>" if you don't want to use it, e.g. if you want to send the message to new subscribers only.

All fields of a "Managed List" have the type Text (or String).

The folloing operators are available:


Equal: = 'string'

e.g.
[Name] = 'Fox'
will return subscribers with the name Fox only
Select the Fieldname: [Name], the Operator: = string and enter the Value: Fox


Unequal: <> 'string'

e.g.
[Name] <> 'Fox'
will return all subscribers without the name Fox
Select the Fieldname: [Name], the Operator: <> string and enter the Value: Fox


Like: LIKE '%string%'
The like condition is used to specify a search for a pattern in a column.

e.g.
[Name] LIKE 'F%'
will return subscriber with the names that start with an F
Select the Fieldname: [Name], the Operator: LIKE %string% and enter the Value: F%

e.g.
[Name] LIKE '%x'
will return subscriber with the names that end with an x
Select the Fieldname: [Name], the Operator: LIKE %string% and enter the Value: %x

e.g.
[Name] LIKE '%FGH%'
will return subscriber with the names that contain the pattern FGH
Select the Fieldname: [Name], the Operator: LIKE %string% and enter the Value: %FGH%


Not Like: NOT LIKE '%string%'

You can use the same operators as in LIKE, but the result will be the opposite (NOT LIKE).


In: IN string1, string2, ...

will return the subscriber where the fieldvalue is string1, string2, ..., or string_x.

e.g.
[Name] IN ('Fox','John','Susan','Pamela')
will return subscriber with the name Fox, John, Susan or Pamela only.
Select the Fieldname: [Name], the Operator: IN string1, string2, ...
and enter the Value: Fox,John,Susan,Pamela


The option "New Subscribers only" will send the message only to new subscribers, which have received no list message before. ( [AMLC_RCVD]=0 )

The "WHERE Clause" will be generated automatically based on your selection. The "WHERE Clause" is a string, which will be used to filter the database.

Subsets - Managed List - Samples

This samples are for "Managed List" only – a "Managed List" uses the data-type "String" (text) for all fields.

[Country] = 'USA'
will return Record 1,3,5

[Country] IN ('DK','GER')
will return Record 2,4

[AMLC_EMAIL] LIKE '%@AAA.tld'
will return Record 1,2,4

[Product] = '1099' AND [Country] = 'GER'
will return Record 4

Subsets - Linked List (List linked to an external database)

The Linked (External) List shows all available fields, which could be used to generate a filter. Please type in the query string in the "WHERE Clause". The subset function in the "Linked List" mode is for experts. Beginners should use a "Managed List" instead.

Please note, that the data-type of the field may be different from field to field.


Overview of most used SQL Operators:

SQL Range Operators: < <= > >=

SQL Equality Operators: = <>

SQL Logical Operators: AND OR

SQL - In: [fieldname] IN ('value1','value2','value3', ... );

SQL - Like: [fieldname] LIKE '%substring%'

Please refer to your SQL manual for a complete list of operators and terms.


Samples:

[Age]>21 AND [Product]='ProductA'

[State]='CA' AND [Newsletter]=1

[State] IN ('CA','WA') AND [Orders]<>0