Mon problème
J’ai le message « Your query or comand is syntactically correct but returned no results »
Ma configuration
[center]## System Health
| version | 2021.1.5 |
|---|---|
| installation_type | Home Assistant OS |
| dev | false |
| hassio | true |
| docker | true |
| virtualenv | false |
| python_version | 3.8.7 |
| os_name | Linux |
| os_version | 5.4.79-v8 |
| arch | aarch64 |
| timezone | Europe/Paris |
Home Assistant Cloud
| logged_in | false |
|---|---|
| can_reach_cert_server | ok |
| can_reach_cloud_auth | ok |
| can_reach_cloud | ok |
Hass.io
| host_os | Home Assistant OS 5.10 |
|---|---|
| update_channel | stable |
| supervisor_version | 2021.03.4 |
| docker_version | 19.03.13 |
| disk_total | 28.6 GB |
| disk_used | 3.6 GB |
| healthy | true |
| supported | true |
| board | rpi4-64 |
| supervisor_api | ok |
| version_api | ok |
| installed_addons | File editor (5.2.0), Grafana (6.0.0), AirSonos (3.0.0), Samba share (9.3.0), InfluxDB (4.0.3) |
Lovelace
| dashboards | 1 |
|---|---|
| mode | storage |
| views | 7 |
| resources | 0 |
Bonsoir à tous,
Je n’ai pas de valeurs lorsque j’interroge ma BDD. J’ai le message indiqué plus haut.
Quelqu’un aurait-il une idée ?
Voici ma requête :
SELECT mean("value") AS "mean_value" FROM "home_assistant"."autogen"."m3" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "entity_id"='volume_total_maison' GROUP BY time(:interval:) FILL(null)