One for LUA/HC2 expert...how to get every iteration of a sensor breach?

[dw89 8]

Hi All,

 

I've been pondering this and can't work out a) how to do it b) if its even possible without access to whatever tables HC2 has behind the scenes......

 

I want a descending list by time (and constantly updating) of the last x10 motion/door sensor breaches in the house (for a virtual device).

 

I 'can' and have done this using loops and a pairs order function BUT, and the big BUT, it only works on 'lastBreached' property. So, what this means is I am only getting one iteration per available sensor. So, lets say, 'Kitchen' motion sensor' goes off 'twice' it will only show the latest iteration (by time) of that sensor and not show it twice.

 

Is there any way of getting multiple iterations (much like on the iPad iOS app) without access to tables? I can easily think how to do this in SQL with access but, not without.

 

Any help appreciated.

 

KR, Dave

Please login or register to see this image.

/emoticons/default_icon_biggrin.gif" alt=":-D" />

 

PS Any way of having multiple temporary tables/arrays (say one person sensor) that could store, lets say, last x10 breaches for each sensor? Just something that sprung to mind this second.

 

UPDATE: In case it helps....think I may be on to something here (with help from a post in which A Bewsher stated how to store a table in a VAR)....so...get data on each sensor and constantly update a table (stored in a global var using json encode/decode) for each sensor and then pull back in my original code...'should' work....here's hoping! All without a physical Db table...amazing if is possible!

[dw89 8]

Can anyone tell me max amount of data available to be stored in a global variable in JSON format?

 

KR, Dave

Please login or register to see this image.

/emoticons/default_icon_biggrin.gif" alt=":-D" />

[entire 3]

Not sure if this is what you are after but on v3.600 this

//hc2-IP/api/panels/event?from=datetime&to=datetime

Returns a Json table of events

You can drop the to parameter and get all the events from the specified time to the present

Cheers

Mike

[dw89 8]

Thanks mate,

Yup that seems like another way to do it, sure;)

To be honest I might try both. I have a feeling that doibg what youve suggested will take longer (as in code processing time rather than coding) as it will bring a lot back. Still will give a go, thabks for tip...didnt think of that and its an 'obvious' solution.

Thanks