Skip to main content
Version: Streamsheets 2.5

TIMESCALE.SELECT

star This is a Streamsheets Enterprise 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

NameDescription
StreamStream to use for querying. The database name is configured in the affiliated Connector.
SelectJSONDefines 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

TSA

FormulaResultComment
=TIMESCALE.SELECT(, JSON(E17:F19), B17:E41)
TRUEThis query returns all values stored in the table "TimescaleDbtable", with a limit of 10.

For more examples see our timescale tutorial.