Load list column from query

A query that may return multiple rows, collected into a single list-typed column accessible to subsequent RowAction ingredients (e.g. for use with ForEachListElement)

Ingredient Family: rowActionsIngredients

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

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 returning rows to collect into a list column

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

• newColumn : new column (type: list of queryTable’s full row type)
  The name of the new list column to create