INFLUX.SELECT
This is a premium feature.
Performs a SELECT query on your Influx database. You can use the Function Wizard for this function.
Syntax
=INFLUX.SELECT(Producer, JSON, [Target], [XValue], [Instant], [Timeout])
Arguments
| Name | Description |
|---|---|
| Producer | Producer to use for querying. The database name is configured in the affiliated Connector. |
| JSON | 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. |
| XValue (optional) | Name of the value which should be used for the x-axis if result is visualized by a chart. Defaults to "time". |
| Instant (optional) | If set to true the select query is immediately performed. Note: use with care, since this can overload InfluxDB very quickly. Default is false. |
| Timeout (optional) | Defines Timeout to perform query. |
Return
TRUE, if no error.
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Select all stored variables from the table A from the past hour, where A equals 4 and B is between 1 and 9. |
info
Designed for Influx version 1.x.