From scalar query

Set a column to a single value from a SQL query. The query MUST return exactly one row with exactly one column. Use this for scalar lookups like COUNT, SUM, MAX, or fetching a single field. For queries returning multiple rows, use QueryList instead.

Ingredient Family: mappingIngredientsList

Outline Display: Set output {{columnName}} to single value from query {{query}}

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: any type)
  The field we want to set
  Set ty only when columnName names a new column (not in $matchTable).

• query : SQL query
  A SQL query returning exactly one row with one column (e.g., SELECT COUNT(*) AS “Total” FROM …)

  Must produce: result named Value matching any type, then no more results
  Scope: all columns of $inputsTable (reference as [ColumnName], e.g., [Name], [Price]).