data_core:connect_to_ip.21.rest_api_via_app_store_connect
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