Multiple replacements for a single datapicker (PRO)
1. Add multiple columns to your SQL query
Text: Displayed in the replace dialog to help the user select the correct data set
Replacement: Replacement for the Placeholder
Additional Replacement: Each value will be mapped to a optional Placeholder defined in the Placeholder Macro
The Description will help to fill out optional Placeholders in the Placeholder Macro.
2. Add a Placeholder Macro to your template
The description can now help to fill out the optional/additional Placeholders.
It doesn’t matter which one is the primary Placeholders.
It is also possible to only use the first additional Placeholders or none at all, but the order has to be the same as it is in the SQL query. The additional Placeholders are optional.
3. Instantiate your template
Now only the primary Placeholder will be displayed, and the first column of the SQL query (Text) appears to help select the replacements.
The other two additional Placeholders are filled out automatically in the background.
All three Placeholders are now replaced.