Publishers are used to send data to a destination. It is possible to use multiple publishers within the same Duty, for instance you might want to write data both to the Dashboard and send an email to a user.
All publishers within a duty will receive the same input – the last output from the latest Collector within the duty.
When publishing, the parameters for the publisher can use dynamic values, meaning values from the input. This could for instance be an email address to send to, or data that you want to have in the subject or body of an email.
The following dynamic parameters, or variables, can be used in any text field parameter for any publisher and it will be replaced with the variable value when publishing. The variable can be set anywhere in the text field, meaning it’s possible to write static text before or after the variable.
In some variables, you can supply a column name to indicate what data to use for the specific function.
| Type | Variable | Example usage |
|---|---|---|
| Sum | $$SUM(columnname)$$ | Order amount is $$SUM(price)$$ |
| Table | $$TABLE()$$ | List content $$TABLE()$$ |
| Number of rows | $$NUMROWS()$$ | There are $$NUMROWS()$$ rows |
| All values in column, separated by comma | $$ALL(columnname)$$ | All item numbers: $$ALL(item)$$ |
| First row field | $$FIRST(columnname)$$ | First item number: $$FIRST(item)$$ |
| Each row field* | $$CURRENT(columnname)$$ | Current item number: $$_ CURRENT(item)_$$ |
| Last row field | $$LAST(columnname)$$ | Last item number: $$LAST(item)$$ |
| Duty name | $$DUTY()$$ | The duty name: $$DUTY()$$ |
| Date (yyyyMMdd) | $$DATE()$$ | Date: $$DATE()$$ |
| Time (HHmm) | $$TIME()$$ | Time: $$TIME()$$ |
| DateTime (yyyyMMdd HHmm) | $$DATETIME()$$ | DateTime: $$DATETIME()$$ |
| TImestamp with milliseconds | $$TIMESTAMP()$$ | Timestamp: $$TIMESTAMP()$$ |
Note that $$CURRENT()$$ can only be used for publishers that have a Run for each row-parameter. If used for a publisher that doesn’t have this parameter, then it will behave as $$FIRST(columnname)$$.