Load joined text from query

Join the single text column of a query’s rows, in the query’s order, into one new text column accessible to subsequent RowAction ingredients

Ingredient Family: rowActionsIngredients

Outline Display: Join the rows of {{query}} with {{separator}} between them, into a new column called {{newColumn}}.

Details

The query returns one column, named Value, and any number of rows; the step joins the rows’ values with separator between them. The rows are joined in the order the query returns them, so give the query an ORDER BY. This is how rows stored one piece at a time – the sections Load list column from text produced, say – are put back together, with the query’s WHERE deciding which pieces are included. A query that returns no rows gives the empty string and the step still completes. Follow it with a Require when an empty result should stop the action.

Local scope

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

  • $table – The table to act on

Names introduced within this component’s knobs:

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

Settings

Required

  • query : SQL query
    A query returning one text column named “Value”, ordered the way the rows should be joined
    Must produce: result named Value matching exactly text; required, non-nullable, then no more results
    Scope: all columns of $table (reference as [ColumnName], e.g., [Name], [Price]).

  • separator : constant value (type: text; required, non-nullable)
    The text placed between one row’s value and the next, such as a blank line

  • newColumn : new column (type: text; required, non-nullable)
    The name of the new column, which must not shadow other names