Set via multi-row query

Set fields with a sql query

Ingredient Family: setterIngredientsList

Outline Display: Use a multi-row SQL query to set some fields: {{query}}

Local scope

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

• $settables – The set of fields that are available to be set

Names introduced within this component’s knobs:

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

Settings

Required

• columnName : column of $settables (type filter: exactly text; required, non-nullable)
  The field we want to multi-set

• query : SQL query
  A SQL query that returns a row for each value we want to set

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