Function FindInfo
Finds a value in the database
FindInfo([TABLE_NAME],[GET_COLUMN],[SEEK_COLUMN],[SEEK_VALUE],[DEF_VALUE])Parameters
| # | Type | Passing | Default | Name | Description/Comments |
|---|---|---|---|---|---|
| 1 | string | required | n/a | TABLE_NAME | The table to query |
| 2 | string | required | n/a | GET_COLUMN | The column containing the value to be returned |
| 3 | string | required | n/a | SEEK_COLUMN | The column containing the value to match against |
| 4 | string | required | n/a | SEEK_VALUE | The value to match against |
| 5 | string | optional | empty | DEF_VALUE | The default value to use if the value was not found |
Returns
The field value found during the search
Examples
Example to lookup a borough based on a local authority when running from a property output.
{{FindInfo("BOROUGHS","BOROUGHD","BOROUGH",ALIAS.LOCALAUTH)}}
