 |
|
||||||||||||||||||
Subscription Definition ExamplesGeneral InformationAs a means of helping you build your own expressions, here are some of the typical select criteria and replace statements created using the XBASE Expression Builder. Select CriteriaThese are the XBASE expressions that determine which subscriber records to select. Example 1: For creating labels for all subscription customers who are due any issues in their subscriptions, no matter what publication. Select Criteria SUBSCRIP.ISSUES_LFT>0 Example 2: For creating labels for all customers subscribing to a specific publication. Select Criteria SUBSCRIP.ISSUES_LFT>0 AND SUBSCRIP.PUB_CODE="XX" (where XX stands for any publication code that you have defined previously) Example 3: For selecting customers who have less than 3 issues left (perhaps for including a renewal reminder notice). Select Criteria SUBSCRIP.ISSUES_LFT>0 AND SUBSCRIP.ISSUES_LFT<3 Replacement Statements ExamplesThe replace statements that you include in your subscription definition update the subscription information for the subscribers who are included in your subscription definition. If you want to run labels for a specific mailing other than a subscription mailing, you probably would not want to update or replace any information. Example 1: For changing all new subscribers to "non-new" subscribers.
Example 2: For deducting issues as you send them.
Example 3: For adding to the count of the number of issues sent only for a specific publication code.
|