Set via query

Set fields with a sql query

Ingredient Family: setterIngredientsList

Outline Display: Use a 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: any type)
  The field we want to set

• query : SQL query
  A SQL query that returns one row, where each of the columns are what we want to set

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

• sqlNm : column of queryTab (type filter: any type)
  The field from the query that we’ll use to set