Free domotica! › Forums › How can I …? › Synology NAS › Panel: working with database (e.g. show sum of electricity consumption))
Tagged: database wall plug
This topic contains 2 replies, has 2 voices, and was last updated by djandib 1 year, 2 months ago.
I want to see at a panel at my dashboard the sum of electricity consumption measured by my fibaro wall-plug e.g. from 01.01.2017 until today
I have an existing and fine working database. So the consumption datas are saved and you “just” have to work with them. Unfortunately no idea how
Has anyone an idea or solution?
You can create a virtual device to store this ‘sum’ value.
This is the device you can show in your dashboard.
Then using blocky you can query the database using a custom php block and put the sum inside this virtual device.
OK, I understand, but how is it possible to query the database and work with it?
Working with php I found this:
But as a newbie and never learned php it`s impossible for me to get a result….
I didn`t find any documentation about this in the forum…
You must be logged in to reply to this topic.