SQL returns 'unknown' - Githubissues

snarky-snark / home-assistant-variables

A custom Home Assistant component for declaring and setting generic variable entities dynamically.

Apache License 2.0

274 stars 16 forks source link

SQL returns 'unknown' #95

Closed pdwonline closed 4 months ago

pdwonline commented 1 year ago

I used this to add a simple SQL statement, but get 'unknown' as a result. I can see that something goes wrong, because the attribute last_update does not appear. Also I wonder how I could get this thing to update every minute..

`` db_sql: friendly_name: "db sql query" query: 'SELECT state_id FROM hass_db.states LIMIT 1;' column: 'state_id' attributes: last_update: '{{ now() }}' tracked_entity_id:

sensor.db_connection restore: false

snarky-snark commented 5 months ago

Likely the same cause as #96.