From list query

Set a list-type column to the results of a SQL query. The target column MUST be a list type (list of records). Each row returned by the query becomes an element in the list, wrapped as {N_Value: value}.

Ingredient Family: mappingIngredientsList

Outline Display: Store list of results from query {{query}} in list column {{columnName}}

Local scope

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

• $inputsTable – The input table
• $mappingResult – A table that contains all mapped columns so far
• $matchTable – An optional table that contains columns that we may be trying to set values for

Names introduced within this component’s knobs:

• queryTab – result columns of query (referenceable as a virtual table)

Settings

Required

• columnName : column of $matchTable or new (type filter: list type (optional or required))
  The list-of-records field we want to populate
  Set ty only when columnName names a new column (not in $matchTable).

• query : SQL query
  A SQL query returning the rows to store in the list output

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