Homey Community Forum

Mysql - app - SOLVED


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.

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



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.