no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+===== 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
+//