How to query your data in the InfluxDB add-on user interface, just like with the regular CLI?

[teeeeee]

Hi,

I am using the InfluxDB add-on from the Home Assistant OS add-on store. I have an InfluxDB “measurement” called “state” which is in the database called “homeassistant”. Now, I am familiar with the InfluxDB CLI, and I can access the measurement data no problem. I can use the command
“USE homeassistant”, which now tells the CLI to deal with only the database “homeassistant”. Then I can access the data by using “SELECT * FROM state”, as follows:

Now I want to retreive the data from the measurement state using this user interface which shows in the sidebar after installing the add-on. If I try to “SELECT” measurements in this user interface, it complains that I haven’t chosen the database (like I did via the “USE” command when going through the CLI above):

What’s the standard way of accessing your data through this InfluxDB user interface?

Thanks!

[tom_l]

Here’s an example that should help:

USE "homeassistant"; DELETE FROM "$" WHERE "entity_id" = 'total_cost_today' AND time > '2021-12-23T16:01:00Z' and time < '2021-12-24T04:48:00Z'

i.e. separate your CLI commands with ; in the web interface query text box.

[ssciberras]

I cannot seem to access the CLI, using either SSH or the terminal addon

How do you do this?

[tom_l]

Use the addon web interface as in the screenshot above.