BrowseSQL
In addition to the Administrator, the BrowseSQL statement is used by all the historian services. The Administrator uses the BrowseSQL statement when querying for tags in the Tag Search function, while the services use it to validate the tag configured in the variable sheet or the model.
BrowseSQL can accept the following arguments in the string:
| Argument | Description |
|---|---|
| ?TagId | If called from the Administrator, contains the search string entered by the user. If called from a service, contains the tag configured in the variable sheet or model. |
BrowseSQL must return data in the following format:
| Order | Field | Description |
|---|---|---|
| 1 | Tag Name | The tag name that will be stored in the variable sheet or model configuration. |
| 2 | Tag Description | An associated description displayed in the Administrator “Tag Search” dialog. |
| 3 | Engineering Units | Engineering units of the tag. This is not currently used so can be set to a constant. |
| 4 | Data Type | Data type of the tag. This is not currently used so can be set to a constant. |