Device Events Table - Non-Default Sort Causes Duplicates and Drops Events

I have discovered that when I switch from the default column sort (date) by clicking on another column header (eg. Name), the resorted table of events has the same number of rows as the default sort, but some of the events listed in the new sort are duplicated, usually 1x and seldom 2x.

  • The duplicates appear spread throughout the table, and are almost never consecutively shown.
  • Ignoring the duplicates, the resorted table is an event subset of the default sort of events.
  • The duplicates seem to not be related to the event type, time-of-day, etc.
  • The duplicates over-write other events, dropping them from the view.
  • There does not appear there is a relationship between the dropped and duplicated events.
  • If I return to the default sort, the original events return 100% intact.
  • Since I never looked closely at non-default sort until now, I can't say if this is a new problem.
  • Note that I tested using the "show 100 entries".
  • The rate of duplication/ dropped events varies considerably:
  • On a thermostat device with 885 events (default sort), sorting by Name resulted in 147 dropped events.
  • On a contact sensor device with 120 events ... resulted in 1 dropped event.
  • On a temperature sensor device with 166 events ... resulted in 9 dropped events.

I am on HW Rev C-5, platform ver. 2.3.0.124. Edit: I am using Chrome on Windows. I have added screenshots. And... I discovered that the specific events that get duplicated or dropped changes each time that I toggle the sort.

Are you able to provide a screenshot of some of the examples you are seeing?

Yes! Thanks for looking at this.

I can see what you mean (I didn't at first :slight_smile: ). This will be one for HE staff to look at, maybe @bobbyD can take a look and pass it on to one of the developers if needed?

Haha! It took me a while to catch-on as well... This one played havoc with my trying to diagnose something else. Whatever is the root cause, pagination appears to play a part. I took a look at which pages contain the duplicates, and nearly all are on consecutive pages. Here is a frequency breakdown for my worst-offending event table (thermostat w/ 886 events).