EntrysetSQLQuery
Introduction
This module accepts an Entryset as an input. SQL 'SELECT' statements can then be run against the Entryset as if it were a table in a familiar SQL-compatible Relational Database Management System. The Entryset is always stored in a table called 'prototable'. Only queries beginning with 'SELECT' can be run. The results of the query are output as an Entryset. SQL statements can be entered in the module's Properties Panel or via an Input Connector. The statement can also be parameterized: words beginning with $ are treated as variables, and Input Connectors will be created for them.
Property Panel:
Entryset SQL Module Properties
- SQL Statement
- The SQL statement to run against the module's Entryset.
Input Menu:
Set Entryset
Sets the Entryset that will be queried.
Accepted Datatypes:
- Entryset
- Any Entryset.
Set SQL Statement
Sets the SQL statement to run.
Accepted Datatypes:
- Text
- Valid SQL statement of the SELECT type.
Entryset SQL Query Input Variables → Set Variable [x] (Dynamic Menu)
Sets the value for user defined variable [x] in the current SQL statement.
Accepted Datatypes:
- Any
Do Execute SQL Statement
Executes the current SQL statement.
Accepted Datatypes:
- Any
Output Menu:
Get Result Entryset
Gets an entryset containing the rows selected by the SQL Query.
Output Datatype:
- Entryset