| Selections (tdsmi0170m000) |  |
| Use this session to define selections. The result of a selection is TRUE or FALSE. If the outcome is FALSE, the customer/prospect/marketing project/contact/activity concerned is skipped. Note A selection expression can be defined in the Text Editor. You can check the expression syntax when compiling the expression by choosing Compile Expression from the Specific menu. A selection expression can be very simple or quite complex. On the Options menu of the Text Editor, click Start Zoomsession to retrieve table fields, feature definitions, or feature definition options. You can enter the value bp.turnover.previous.year as a predefined variable in the selection expression. For more information, refer to Predefined variable for selection expressions. Text after the | sign is regarded as comment. With regard to the values of variables you must distinguish between alphanumeric and numeric values. The former must be put between quotation marks ("...."), while the latter can be entered directly. The decimal sign is a dot (.). Selection expressions can be combined with AND and OR constructions. Related topics Relation Management - functionality Relation Management - Text Editor Relation Management - examples of selection expressions
Fields | Description
Selection | The selection code can be used to select data from the database or part of it (if you specify a restricted range in the database). This selection code is unique. After recording a selection, you can define an expression in the Text Manager that can be used to retrieve data from the database for maintenance/printing. A selection is a predefined set of data that must be printed or processed. Such a set is defined by a selection expression (or a selection criterion). Selections are used when you: Globally add feature definitions in the Relation Management module. Mail standard letters and print flexible reports. Globally add and delete activities.
Text | If this check box is selected, a text is used.
Expression | If this check box is selected, an expression is used to set up criteria to retrieve data from the database for maintenance/printing.. Related topics Relation Management - Text Editor Relation Management - examples of selection expressions