New/edit segment advanced tab
The Segments > New Segment > Advanced settings tab allows you to set special parameters for your segment.
New/edit segment advanced tab UI
The table below explains the fields available in the Segments > New Segment > Advanced tab:
| Field Name | Description |
|---|---|
| Join Other Tables |
By default, Aurea List Manager only has access to its database tables. To access data in other tables in your database, list the table names here, separated by commas. Carriage returns are not allowed in this field, to prevent errors resulting from not separating correctly with commas. The standard members table is already included, and need not be specified. The fields in the tables specified here are available for mail merging For example: demographics. customers, demographics.info Adding additional tables here makes their fields appear when inserting a clause Note
For example: Use |
|
Columns to display |
This setting is only relevant for testing purposes to see what data is returned when you test your segment.
If blank, only For example:
|
| Sorting |
Using an SQL For example:
|
| After SELECT | This setting is useful for those using Aurea List Manager with an Oracle database to tell it to use a specific index, thus improving performance. The Oracle optimizer does not always choose to use an index, even if one has been built, so this feature allows the name of the index to be added as a hint after the SQL for the subset |