Yes/No filter

Provide a dropdown that allows the user to filter on a boolean column.

Ingredient Family: sqlFilterIngredients

Outline Display: Filter on boolean column {{columnName}} from table {{table}}

Local scope

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

• $query – The query that will get filtered

Names introduced within this component’s knobs:

• table – table picked from the FROM clause of $query

Settings

Required

• table : table name/alias from the FROM of $query
  The name or alias of the table that has the column we’re filtering by

• columnName : column of table (type filter: exactly bool; required, non-nullable (optional or required))
  An existing boolean column from the table specified by tnm that we are filtering by

• label : constant value (type: text; required, non-nullable)
  The label for the dropdown

Optional

• cssWidth : constant value (type: integer; required, non-nullable)
  Width as an integer between 1 and 12 where 12 is a full row