QUERY - j5 - 28.0 - Administration & Configuration - Hexagon

j5 IndustraForm Designer Reference

Language
English
Product
j5
Search by Category
Administration & Configuration
j5 Version
2019

Evaluates a SQL query client-side using the results of table data functions as input tables.

= QUERY(query[, parameter, ...])

query - The SQL query to evaluate. A subset of the ANSI SQL SELECT statement is supported with one important variation: in the place of table names, for example, in the FROM clause, a question mark parameter marker is used. An import function should then be used to provide the data for that virtual "table" in the query.

parameter - A parameter to pass to the corresponding ? in the query. This can be used to pass values into the SQL (for variable filters etc), but is also used for input tables. The results from IMPORT functions (for example, IMPORT.LOG or IMPORT.SUBLOG) are supported as input tables.

For more information, refer to QUERY function SQL Syntax and QUERY examples.