Hi,
we have faced with the following inconvenience concerning inconsequential records in "service_alarms" table.
As we know "service_alarms" table, should contain records which written in sequential-ascending order in columns: "servicealarmid", "clock".
But sometimes we meet records in not sequential-ascending order. For example, we have two records:
servicealarmid | serviceid | clock | value
23182 | 240 | 1497892536 | 3 (1 records, state: service filed - 3)
23194 | 240 | 1497892279 | 0 (2 records, state: service ok - 0)
(1497892536 - Monday, June 19, 2017 5:15:36 PM)
(1497892279 - Monday, June 19, 2017 5:11:19 PM)
So my question is: Why date & time in 1-st records greater than in the 2-nd record ? While the values in column - "servicealarmid" is correct, i.e. the sequence in sequential-ascending order.
Thanks in advance for any help.
we have faced with the following inconvenience concerning inconsequential records in "service_alarms" table.
As we know "service_alarms" table, should contain records which written in sequential-ascending order in columns: "servicealarmid", "clock".
But sometimes we meet records in not sequential-ascending order. For example, we have two records:
servicealarmid | serviceid | clock | value
23182 | 240 | 1497892536 | 3 (1 records, state: service filed - 3)
23194 | 240 | 1497892279 | 0 (2 records, state: service ok - 0)
(1497892536 - Monday, June 19, 2017 5:15:36 PM)
(1497892279 - Monday, June 19, 2017 5:11:19 PM)
So my question is: Why date & time in 1-st records greater than in the 2-nd record ? While the values in column - "servicealarmid" is correct, i.e. the sequence in sequential-ascending order.
Thanks in advance for any help.