|On this page|
Input node for making a SQL query and creating work items for each row.
Module name of the database driver to use.
Database connection string.
Use Custom Script
When enabled, the node will run the SQL query in the custom script specified in this parameter.
The SQL table name.
This is used to decide if the node will generate a query using SELECT *.
This is used to decide if the node will generate a query using SELECT DISTINCT.
An integral limit for the LIMIT clause.
This is the number of columns.
PDG Value Index
This is used to determine the PDG value index.
PDG Data Type
This is used to determine the PDG data type.
If true, result will be sorted using the "Sort Index" and "Sort Type" parameters.
This is the index used when sorting the columns.
This is used to determine if the sorting should be ascendent or descendent.
If true, the query will be defined by the "Query" parameter instead of generating one.
If "Override Query" is true, this is the SQL query to be executed.
Determines when this node will generate work items. You should generally leave this set to "Automatic" unless you know the node requires a specific generation mode, or that the work items need to be generated dynamically.
All Upstream Items are Generated
This node will generate work items once all of the input nodes have generated their work items.
All Upstream Items are Cooked
This node will generate work items once all of the input nodes have cooked their work items.
Each Upstream Item is Cooked
This node will generate work items each time a work item in an input node is cooked.
The generation mode is selected based on the generation mode of the input nodes. If any of the input nodes are generating work items when their inputs cook, this node will be set to Each Upstream Item is Cooked. Otherwise, it will be set to All Upstream Items are Generated.