How to read logs with javascript

[buuuudzik]

You should prepare .lp file in/user/ location(e.g. logs.lp) and inside you must prepare in lua such script:

Code:

<?

-- How much objects do you need?
objects_number = 10

query = "SELECT ol.logtime, o.name, ol.datahex, o.datatype, ol.eventtype FROM objectlog AS ol, objects AS o WHERE ol.address=o.address AND ol.eventtype IN ('write', 'response') ORDER BY ol.logtime DESC LIMIT " .. objects_number
result = db:getall(query)

logs = {}

for _,row in ipairs(result) do  
    logs[_] = {logtime = os.date('%Y.%m.%d %H:%M:%S', row.logtime), name = row.name, value = knxdatatype.decode(row.datahex, row.datatype)}
end

logs = json.encode(logs)
print(logs)

?>

And when you will have this file you can use it in js by:

Code:

$.get( "/user/logs.lp", function( data ) {
   res = data.trim();
   res = JSON.parse(res);
// further operating with data in javascript ;)
 };