21
Users / Re: Energy Monitor configuration?
« Last post by cfernandes on April 11, 2022, 02:21:09 pm »Hi,
what i need to inser in field whats ?
i take a look in query and changed to
$deviceQuery = mysql_query('SELECT EK_Device, Description, IK_DeviceData FROM Datapoints, pluto_main.Device, pluto_main.Device_DeviceData WHERE (FK_Unit=5 or FK_unit=7) AND EK_Device=PK_Device AND EK_Device=FK_Device AND FK_DeviceData=289
GROUP BY EK_Device ORDER BY FK_Room');
and now this show all devices than report energy Consumption
what i need to inser in field whats ?
i take a look in query and changed to
$deviceQuery = mysql_query('SELECT EK_Device, Description, IK_DeviceData FROM Datapoints, pluto_main.Device, pluto_main.Device_DeviceData WHERE (FK_Unit=5 or FK_unit=7) AND EK_Device=PK_Device AND EK_Device=FK_Device AND FK_DeviceData=289
GROUP BY EK_Device ORDER BY FK_Room');
and now this show all devices than report energy Consumption