Feature #17295
Updated by Krzysztof Putyra 8 months ago
The syntax <pre> <value> AS 'col1|col2|col3' </pre> can represent a processing queue of @value@ by three processors with the output of last one taken takes as the column value. In this example the process queue is <pre> +------+ +------+ +------+ <value> -->--| col1 |-->--| col2 |-->--| col3 |-->-- <processed> +------+ +------+ +------+ </pre> Notes: * a column name that do not begin with an underscore is processed by the default processor that saves the value in the R-store and forwards it to the next processor * a column name @_<name>@ that is not a special column name is semantically equal to @_hide|<name>@ * this feature is compatible with the current approach, where only one special column is allowed and it must be the first one; @_hide@ and @_nowrap@ are the only exception and both must be currently at the end; with this feature the position of @_hide@ and @_nowrap@ is irrelevant. **Example** <pre> 10.sql=SELECT 'Hello world!' AS 'plain|_encrypt|encrypted|_hide' 10.10.sql=SELECT 'Plain text: {{plain:R}}<br>Encrypted text: {{encrypted:R}}' </pre> produces <pre> Plain text: Hello world! Encrypted text: <encrypted> </pre>