LUA read historical data from temperature panel

[MichalCZ 2]

Hello, I want to read historical data from temperature panel.

I want to know maximal temperature from sensor in last 24 hours. Can I read "last 24h" from temp. panel and find maximal value?

Thanks for support.

[10der 832]

UPD: 

Please login or register to see this link.

Please login or register to see this attachment.

[10der 832]

Yes, you can.

http://iphc2/docs 

topic panels waiting for you.

if not, ask me again  

Edited October 27, 2019 by 10der

[MichalCZ 2]

On 10/27/2019 at 8:42 PM, 10der said:

UPD: 

Please login or register to see this link.

 

 

Thank you very much!

Last one is perfect.

[mmklos 0]

W dniu 27.10.2019 o 20:36, 10der napisał:

Yes, you can.

http://iphc2/docs 

topic panels waiting for you.

if not, ask me again  

Hi, @10der!

When I tried this:

http://192.168.1.2:80/api/temperature/now-3600000/now/summary-graph/devices/temperature/249

it only shows me data from the last 10 hours. How can I configure fibaro to get temp historical data from even past months?

[A.Socha 133]

Cytat

now-3600000

change value

now - from today

3 600 000 - time how much you want go back

 

 

 

 

[mmklos 0]

25 minut temu, A.Socha napisał:

change value

now - from today

3 600 000 - time how much you want go back

 

 

 

 

@A.Socha,

yes, but, as I wrote, the issue is that whatever value I set, I get temp historical data from the past 10 hours only. My question is: is there any configuration I can make in HC2 to have longer period of temp historical data?

[10der 832]

@mmklos actually HCx (IMHO) unallotted for using as DataBase server  

please poll HCx endpoints and grab periodically interesting for u data and stroring it locally.

otherwise sorying a big data in SQLite it's not a good idea and can make some arteffacts in system.

IMHO again

[mmklos 0]

Ok, thanks for clarification ?

[A.Socha 133]

There is a limit on HCL how much energy event you can have. If i remember good that is 40 000 records so if you got there more  report it is shorter time what we keep on device, if you want keep all data you can easy send them to other service every for example 2 weeks

[petergebruers 1,268]

A related question with some suggestions to work around the limited data storage on the HC...