Homey Community Forum

Mysql - app - SOLVED

#1

I have 10 years of energy measures in a MYSQL database.
I downloaded this app but dont get it to work. Dont see any numbers.

https://apps.athom.com/app/nl.rebtor.sql
The query I am using looks like this.
SELECT counts_a_60 AS ‘power’, counts_a_24 AS ‘meter’ FROM answers a ORDER BY Created DESC LIMIT 1;

I can test my sql statement in query browser and it returns values ok, see picture

image

#2

I now got it working. And I think it was something when entering query in the app on my Iphone. Because when I logon http://developer.athom.com/ and added the device there and copy/paste the query and other fields it starts working. So maybe some characters got wrong when writing it on my iphone.