Description
Returns a list of aliases for a string from a lookup table.
Syntax
ALIASLIST ( TextSourceField, "connection", "table", "field" )
| Parameter | Description |
|---|---|
| TextSourceField | The value to search for in the lookup table. |
| connection | The name of the connection where this lookup table resides.
If the connection is Scribe Internal Database, the SCRIBE user must have at least SELECT privileges on the lookup table. |
| table | The name of the lookup table. |
| field | The name of the field containing the lookup values. |
Remarks
The lookup is not case sensitive. Use ALIASLIST with the IN operator for lookup links. If the lookup value is not found in the table, the function returns the value that was passed in.
Examples
The following example stores alias names in the FirstName field of the NAMES table in a target database (where the connection name is Target).
| Names |
|---|
| FirstName |
| 'Bill', 'Billy', 'Will', 'William' |
| 'James', 'Jim', 'Jimmy' |
This function returns 'Bill', 'Billy', 'Will', 'William':
ALIASLIST("William", "Target", "NAMES", "FIRSTNAME")
See also