TIMESCALE.SELECT

Premium

Performs a SELECT query on your timescale database.

info

As of right now, the timescale functions work with the internal timescaledb. Leave the Connection parameter empty and the connection is automatically set up. We are working on allowing further timescale connections.

Syntax

=TIMESCALE.SELECT(Connection, SelectJSON, [Target], [XValue])

Arguments

Name	Type	Description
Connection	Connection	Connection to use for querying. Leave this parameter empty. The internal timescaledb is automatically connected.
SelectJSON	JSON	Defines a query using a JSON cell range, which contains all clauses to build the SELECT query.
Target (optional)	Target	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.
XValue (optional)	String	Name of the value which should be used for the x-axis if result is visualized by a chart. Defaults to "time" Default value: "time"

Return

Type	Description
Boolean	TRUE, if successful.

Examples

	A	B	C
1	select	*
2	from	TimescaleDbTable
3	limit	10
4
5	Cats	Dogs	time
6	93	50	8:01:07
7	23	51	8:01:08
8	94	52	8:01:09
9	14	53	8:01:10
10	54	54	8:01:11
11	65	55	8:01:12
12	12	56	8:01:13

Formula	Result	Comment
=TIMESCALE.SELECT(, JSON(A1:B3), A5:C12)	TRUE	This query returns all values stored in the table "TimescaleDbtable", with a limit of 10.

For more examples see our timescale tutorial.