NodeParameterized Database Query (legacy)

Source

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

This node runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.

Input Ports

  1. Port Type: Data
    Data column with possible values used to constrain the database SQL query
  2. Port Type: Database Query
    A database query connection that will be used to connect to the database

Output Ports

  1. Port Type: Data
    Table with data read from the database and optionally the data from the input table
  2. Port Type: Data
    Table with error message if any, otherwise empty table