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.