The SQL Editor is designed to enhance working with the Query Builder.
The SQL Editor allows you to write SQL queries or import existing PSR files into Smart Instrumentation, and then convert them into the Query Builder format. When the imported SQL is in the Query Builder format you can manipulate the data and then use these query templates for different actions. For example, creating EDEs or Find queries.
The SQL Editor supports the following statements:
-
Aliases
-
SELECT columnA, ColumnB, columnC FROM
-
SELECT columnA "Column A", columnB "ColumnB", columnC "Column C" FROM
-
SELECT columnA AS "Column A", columnB AS "ColumnB", columnC AS "Column C" FROM
-
-
Distinct — SELECT DISTINCT
-
All forms of FROM and JOIN
-
Union— Union is supported, but not converted to query builder. The SQL Editor "Flattens" and Merges the unions into a single select.
-
The SQL statement cannot be saved when the SQL contains duplicate column names without an alias.
-
The SQL editor preview and a view only EDE generated from an SQL query, displays all data that meets the query requirements even if access rights in the Administration module have been set to Access Denied.
-
A collection of sample SQL's can be found in the folder SQL in the folder where Smart Instrumentation was installed.