TIMESCALE.SELECT
This is a premium feature.
Performs a SELECT query on your timescale database.
info
As of right now, the timescale functions work with the internal timescaledb. Leave the Stream parameter empty and the connection is automatically set up. We are working on allowing further timescale connections.
Syntax
=TIMESCALE.SELECT(Stream, SelectJSON, [Target], [XValue])
Arguments
| Name | Description |
|---|---|
| Stream | Stream to use for querying. The database name is configured in the affiliated Connector. |
| SelectJSON | Defines a query using a JSON cell range, which contains all clauses to build the SELECT query. |
| Target (optional) | INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed. You don´t need a target area , if you only want to display charts. You can directly reference the cell with the query. (make sure you Xvalue parameter is set right) |
| XValue (optional) | Name of the value which should be used for the x-axis if result is visualized by a chart. Defaults to "time". |
Return
TRUE, if successful.
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | This query returns all values stored in the table "TimescaleDbtable", with a limit of 10. |
For more examples see our timescale tutorial.