For /reading SolarQuery API queries, unexpected results when datum properties are inconsistent

XMLWordPrintable

    • 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).

            Assignee:
            Matt Magoffin
            Reporter:
            Matt Magoffin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: