-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major
-
Component/s: DB, SolarQuery
-
None
For the /reading style SolarQuery API queries, unexpected results can be returned on datum streams that hold records of "incomplete" datum around the given start/end dates. By "incomplete" I mean that an accumulating property is only present sometimes, but it is desirable to get an actual reading based on the datum where that property is present.
For example, given a datum stream like:
Date | Status | Meter |
---|---|---|
00:00 | 0 | 100 |
00:05 | 0 | 101 |
00:10 | 0 | 102 |
00:15 | 1 | |
00:20 | 1 | |
00:25 | 1 | |
00:30 | 0 | 103 |
And a Difference query date range of 00:00 - 00:15, the current result would have the reading date range of 00:00 - 00:15 but would not have a result value for Meter, because the 00:15 datum does not have a Meter value. The desired result would have a reading date range equal to 00:00 - 00:10 and a Meter result value of 2 (102 - 100).
- blocks
-
EP-3132 Loading...