Load column from query

A query to add more values to the row, which will be accessible to subsequent RowAction ingredients

Ingredient Family: rowActionsIngredients

Outline Display: Add data from {{newColumnQuery}} to the data we’re processing.

Details

The query must produce exactly one row. If it produces none, the step fails the action with a malfunction message and the rest of the pipeline does not run. That makes this the fail-closed way to state an assumption about data that must exist: fetch the row you need here, and the action stops with a message when it is missing. Formulas cannot do this – a formula over a column that is absent or NULL evaluates to a default and reads as benign. To check a value you already have rather than one you must fetch, use Require.

Local scope

The parent slot binds these (look up the slot in the parent to see how):

• $table – The table to act on

Names introduced within this component’s knobs:

• queryTable – result columns of newColumnQuery (referenceable as a virtual table)

Settings

Required

• newColumnQuery : SQL query
  A query producing exactly one row, which we will append to the current row we’re processing

  Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price]).