Parameterized Database Query (legacy)
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.
- Type: Data Data column with possible values used to constrain the database SQL query
- Type: Database Query A database query connection that will be used to connect to the database
- Type: Data Table with data read from the database and optionally the data from the input table
- Type: Data Table with error message if any, otherwise empty table