On this page
Since 17.5

Input node for making a SQL query and creating work items for each row.

Parameters

Input

Driver

Module name of the database driver to use.

Database

Database connection string.

Use Custom Script

When enabled, the node will run the SQL query in the custom script specified in this parameter.

Table Name

The SQL table name.

Force Regenerate Query

Regenerates the query based on the current parameters.

Extract All

This is used to decide if the node will generate a query using SELECT *.

Distinct

This is used to decide if the node will generate a query using SELECT DISTINCT.

Limit

An integral limit for the LIMIT clause.

Columns

This is the number of columns.

Column Name

Column name.

Rename Column/Tag

Column alias.

PDG Value Index

This is used to determine the PDG value index.

PDG Data Type

This is used to determine the PDG data type.

Enable

If true, result will be sorted using the “Sort Index” and “Sort Type” parameters.

Sort Index

This is the index used when sorting the columns.

Sort Type

This is used to determine if the sorting should be ascending or descending.

Generated Query

Override Query

If true, the query will be defined by the “Query” parameter instead of generating one.

Query

If “Override Query” is true, this is the SQL query to be executed.

Processor

Generate When

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.

Automatic

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.

Examples

example_top_sqlinput Example for SQL Input TOP node

This example demonstrates how to use the SQL Input node to query information from a SQLite database and store that information as work item attributes.

TOP nodes