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