Record Selection commands used by customer messages

 

Related Topics

 

 

 

Several sample record selection commands are provided with H2OS in the SQL Commands Library.

 

You can access the Select commands library from the menu -> librarian -> SELECT Library

 

If you don't see a sample using criteria you wish to use please describe your requirement to us and we'll see if we can fashion the command for you.

 

Customer Messages uses SQL SELECT commands to select recipients for batch messages

 

 

 

The SQL Select Command Library screen is shown below (with the 'show both descriptions and commands' option selected, which expands the grid to include the actual SQL command and it's description):

 

 

 

 

The full range of record selection possibilities challenges the imagination.

 

Some examples:

 

 

 

Note that 'Customer' is used generically. Actually the database used can be any which includes the needed information, such as the Prospects database.