| Table of Contents |
|---|
...
The SQL to run. This SQL can contain almost anything you would like. NOTE
NOTES:
- do not use single quotes, please use escaped double quotes, eg: \"value\" instead of 'value'
- do not use SELECT *, specify the columns you need, * will not work.
query subsitutions
Currently supported subsitutions are:
...
Example: SELECT * FROM interface WHERE UNIX_TIMESTAMP(lastUpdate) >= time.start AND UNIX_TIMESTAMP(lastUpdate) < time.end AND customerName = user.customer
groupby:
If the data returned from the SQL statement needs to be grouped (for summing or counting, works much like SQL GROUP BY) use this field to specify the group, as an array, order matters. This works in tandem with the aggregation function to produce results. Just like in an SQL GROUP BY each column requires a function to aggregate it's result.
...