User Tools

Site Tools


Configuring SQL tag search statement

When configuring your own SQL statement to perform a tag search make sure to include 3 columns in your query: Name - column for tag name search results (required). Description - column for tag descriptions (optional). UOM - column for tag engineering units (optional).

Most importantly please add $FILTER variable in your LIKE filter to make sure that results are filtered by users input. See an example below.

An example of such query:

SELECT ar.Name AS Name,ar.Definition AS Description, amd.MAP_Description AS UOM, amd.MAP_SomeColumn FROM all_records AS ar INNER JOIN AtMapDef as amd ON ar.Definition = amd.MAP_DefinitionRecord WHERE ar.Name LIKE '$FILTER' ORDER BY ar.Name

data_core/connect_to_ip.21.rest_api_via_app_store_connect.txt · Last modified: 2020/02/24 09:03 by su