<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Hallo Andreas,<br>
    <br>
    das ist vom ersten Wert bis jetzt, oder?<br>
    Das gibt ne lange Liste (siehe Anhang)<br>
    <br>
    Da steht dann bei consumption 1490 drin. <br>
    Ist ja auch der Verbraúch seit der Aufzeichnung.<br>
    <br>
    Wird da aber nirgends der Initailverbrauch drauf gerechnet oder
    angezeigt, oder? <br>
    So dass ich es nicht selbst machen muss und an mehreren Stellen dran
    denken muss?<br>
    <br>
    Oder kann ich den Eintrag des Initialverbrauchs auch irgendwie
    abfragen?<br>
    <br>
    Danke<br>
    <br>
    Gruß<br>
    Thomas<br>
    <br>
    <br>
    <div class="moz-cite-prefix">Am 08.04.2021 um 09:55 schrieb Andreas
      Goetz:<br>
    </div>
    <blockquote type="cite"
      cite="mid:9A768F9B-83AE-45F5-BA46-46B6374504DD@gmail.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      Entschuldige, Deine Timestamps scheinen zu passen in ms. Bei Post
      kannst Du die aber weglassen- die Middleware wird sie selbst
      erzeugen.
      <div class=""><br class="">
      </div>
      <div class="">Bzgl. Abfrage probier mal bitte ?from=1&to=now</div>
      <div class=""><br class="">
      </div>
      <div class="">Viele Grüße, </div>
      <div class="">Andreas</div>
      <div class=""><br class="">
        <div><br class="">
          <blockquote type="cite" class="">
            <div class="">On 8. Apr 2021, at 09:42, <a
                href="mailto:Heine.Thomas@online.de" class=""
                moz-do-not-send="true">Heine.Thomas@online.de</a> wrote:</div>
            <br class="Apple-interchange-newline">
            <div class="">
              <meta http-equiv="Content-Type" content="text/html;
                charset=UTF-8" class="">
              <div class=""> Hallo Andreas,<br class="">
                <br class="">
                ich steh grade auf dem Schlauch. An welcher Stelle seht
                ihr denn falsche Zeitstempel?<br class="">
                Welcher Konverter? Das ESP?<br class="">
                <br class="">
                Das ESP sendet die Daten an Node-Red. Dort setze ich mir
                den Post-Befehl selbst zusammen. <br class="">
                Ich nehme den Counter-stand und setze die UUID und einen
                aktuellen Zeitstempel mit dran.<br class="">
                <span id="cid:part1.84A825EF.F0AD9121@online.de"><bhjgbnpbhbfpehmc.png></span><br
                  class="">
                <br class="">
                ich poste es wie folgt:<br class="">
                <span class="red-ui-debug-msg-payload"><span class="
                    built red-ui-debug-msg-element
                    red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header"><a
                              class="moz-txt-link-freetext"
                              href="http://192.168.178.51/middleware.php/data/"
                              moz-do-not-send="true">http://192.168.178.51/middleware.php/data/</a></span></span></span></span></span></span>xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx<span
                  class="red-ui-debug-msg-payload"><span class=" built
                    red-ui-debug-msg-element red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header">.json?ts=</span></span></span></span></span></span><span
                  class="red-ui-debug-msg-payload"><span class=" built
                    red-ui-debug-msg-element red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header"><span
                              class="red-ui-debug-msg-payload"><span
                                class=" red-ui-debug-msg-element built
                                red-ui-debug-msg-top-level"><span
                                  class="red-ui-debug-msg-element"><span
                                    class="red-ui-debug-msg-row"><span
                                      class="red-ui-debug-msg-object-value"><span
                                        class="
                                        red-ui-debug-msg-object-header
                                        red-ui-debug-msg-type-string
                                        ">1617867468039</span></span></span></span></span></span>&value=147<br
                              class="">
                            <br class="">
                            Die post-response:<br class="">
                            {"_msgid":"99863cea.a330b","uuid":"</span></span></span></span></span></span><span
                  class="red-ui-debug-msg-payload"><span class=" built
                    red-ui-debug-msg-element red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header"><span
                              class="red-ui-debug-msg-payload"><span
                                class=" red-ui-debug-msg-element built
                                red-ui-debug-msg-top-level"><span
                                  class="red-ui-debug-msg-element"><span
                                    class="red-ui-debug-msg-row"><span
                                      class="red-ui-debug-msg-object-value"><span
                                        class="
                                        red-ui-debug-msg-object-header
                                        red-ui-debug-msg-type-string
                                        "></span></span></span></span></span></span>xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx","timestamp":1617867468039,"url":"<a
                              class="moz-txt-link-freetext"
                              href="http://192.168.178.51/middleware.php/data/"
                              moz-do-not-send="true">http://192.168.178.51/middleware.php/data/</a></span></span></span></span></span></span><span
                  class="red-ui-debug-msg-payload"><span class=" built
                    red-ui-debug-msg-element red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header"><span
                              class="red-ui-debug-msg-payload"><span
                                class=" red-ui-debug-msg-element built
                                red-ui-debug-msg-top-level"><span
                                  class="red-ui-debug-msg-element"><span
                                    class="red-ui-debug-msg-row"><span
                                      class="red-ui-debug-msg-object-value"><span
                                        class="
                                        red-ui-debug-msg-object-header
                                        red-ui-debug-msg-type-string
                                        "></span></span></span></span></span></span>xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json?ts=1617867468039&value=147","statusCode":200,"headers":{"date":"Thu,
                            08 Apr 2021 07:37:48
                            GMT","server":"ReactPHP/1","cache-control":"no-cache,
private","content-type":"application/json","access-control-allow-origin":"*","content-length":"26","connection":"close","x-node-red-request-node":"39370292"},"responseUrl":"<a
                              class="moz-txt-link-freetext"
                              href="http://192.168.178.51/middleware.php/data/"
                              moz-do-not-send="true">http://192.168.178.51/middleware.php/data/</a></span></span></span></span></span></span><span
                  class="red-ui-debug-msg-payload"><span class=" built
                    red-ui-debug-msg-element red-ui-debug-msg-top-level
                    "><span class="red-ui-debug-msg-element"><span
                        class="red-ui-debug-msg-row"><span
                          class="red-ui-debug-msg-object-value"><span
                            class=" red-ui-debug-msg-type-string
                            red-ui-debug-msg-object-header"><span
                              class="red-ui-debug-msg-payload"><span
                                class=" red-ui-debug-msg-element built
                                red-ui-debug-msg-top-level"><span
                                  class="red-ui-debug-msg-element"><span
                                    class="red-ui-debug-msg-row"><span
                                      class="red-ui-debug-msg-object-value"><span
                                        class="
                                        red-ui-debug-msg-object-header
                                        red-ui-debug-msg-type-string
                                        "></span></span></span></span></span></span>xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json?ts=1617867468039&value=147","payload":{"version":"0.3","rows":1},"redirectList":[]}<br
                              class="">
                          </span></span></span></span></span></span><br
                  class="">
                Ist hier irgend ein Fehler versteckt?<br class="">
                <br class="">
                Gruß<br class="">
                Thomas<br class="">
                <br class="">
                <div class="moz-cite-prefix">Am 08.04.2021 um 09:01
                  schrieb Andreas Goetz:<br class="">
                </div>
                <blockquote type="cite"
                  cite="mid:950CE498-4340-4180-A629-7A4989D67FD8@gmail.com"
                  class="">
                  <meta http-equiv="Content-Type" content="text/html;
                    charset=UTF-8" class="">
                  Die VZ Zählerstände sind in Millisekunden- der
                  Konverter vmtl. Sekunden? 
                  <div class=""><br class="">
                  </div>
                  <div class="">Viele Grüße, Andreas</div>
                  <div class=""><br class="">
                    <div class=""><br class="">
                      <blockquote type="cite" class="">
                        <div class="">On 8. Apr 2021, at 09:00, <a
                            href="mailto:Heine.Thomas@online.de"
                            class="" moz-do-not-send="true">Heine.Thomas@online.de</a>
                          wrote:</div>
                        <br class="Apple-interchange-newline">
                        <div class="">
                          <meta http-equiv="Content-Type"
                            content="text/html; charset=UTF-8" class="">
                          <div class=""> Hallo Thomas,<br class="">
                            <br class="">
                            Wenn ich es so abfrage:<br class="">
                            <a class="moz-txt-link-freetext"
href="http://192.168.178.51/data/xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json"
                              moz-do-not-send="true">http://192.168.178.51/data/xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json</a><br
                              class="">
                            kommt folgendes:<br class="">
                            <br class="">
                            <pre class="data">{"version":"0.3","data":{"tuples":[[1617777764306,0,1]],"uuid":"xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx","from":1617777464308,"to":1617777764306,"min":[1617777764306,0],"max":[1617777764306,0],"average":0,"consumption":0,"rows":2}}</pre>
                            consumption bleibt 0 (ist das nicht der
                            Aktualverbrauch?)<br class="">
                            <br class="">
                            Ich hab ja keinen Impuls-Kanal, sondern
                            einen Zählerstand-Kanal.<br class="">
                            In Frontend wird der Gesamtverbrauch ja auch
                            richtig angezeigt (aufgerundet 136m³):<br
                              class="">
                            <br class="">
                            <span
                              id="cid:part1.053637A1.064BEA67@online.de"
                              class=""><ajjlibndepcjlagi.png></span><br
                              class="">
                            <br class="">
                            Den Gesamtverbrauch (müsste ja der
                            Zählerstand sein) würde ich gerne anzeigen.<br
                              class="">
                            Oder habe ich hier irgendwas nicht richtig
                            kapiert, oder Grundlegende Denkfehler?<br
                              class="">
                            <br class="">
                            Der Counter-Stand des ESP kann doch auch als
                            Zählerstand mit dem entsprechenden Offset
                            und Initialverbrauch als "Zähler" dienen,
                            oder?<br class="">
                            <br class="">
                            <span
                              id="cid:part2.C4529F81.DE723253@online.de"
                              class=""><lppmegjjoipaghpl.png></span><br
                              class="">
                            <br class="">
                            <br class="">
                            <br class="">
                            Was stimmt bei den Zeitstempeln nicht? Wenn
                            ich sie im Unix-Time-Converter eingebe,
                            passen sie.<br class="">
                            <br class="">
                            Gruß Thomas<br class="">
                            <br class="">
                            <br class="">
                            <div class="moz-cite-prefix">Am 08.04.2021
                              um 08:40 schrieb Thomas Höpfner:<br
                                class="">
                            </div>
                            <blockquote type="cite"
                              cite="mid:kcis.E96F4CE7F9EC43BAB1F37674F3DFCA70@rohrpostix"
                              class="">
                              <meta name="Generator" content="Kopano
                                WebApp v3.5.14.2539+111.1" class="">
                              <meta http-equiv="Content-Type"
                                content="text/html; charset=UTF-8"
                                class="">
                              <title class="">RE: [vz-users] Abfrage
                                Zählerstand aus Wasserzähler</title>
                              <!-- begin sanitized html -->
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class="">Hallo Thomas,</div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class=""><br
                                    class="">
                                </span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class="">die
                                  Zeitstempel stimmen nicht. Wie PHP
                                  hier reagiert verstehe ich auch nicht.</span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class="">options=raw
                                  kanst du weglassen. Hier bekommst du
                                  nur eine Liste mit allen Impulsen.
                                  Interesand ist aber nur die Anzahl,
                                  die steht dann auch als consumtion in
                                  der Antwort.</span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class="">Ich
                                  sehe im Moment keine Möglichkeit den
                                  aktuellen Zählerstand eines
                                  Iipulszählers aus vz auszulesen.</span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class=""><br
                                    class="">
                                </span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><span style="font-size:
                                  12pt; font-family: tahoma, arial,
                                  helvetica, sans-serif;" class="">Thomas </span></div>
                              <div style="padding: 0px; margin: 0px;
                                min-height: 12pt; font-family: tahoma,
                                arial, helvetica, sans-serif; font-size:
                                12pt;" class=""><br class="">
                              </div>
                              <blockquote style="border-left: 2px solid
                                #325FBA; padding-left: 5px; margin: 0px
                                5px;" class=""><span style="font-family:
                                  tahoma,arial,helvetica,sans-serif;
                                  font-size: 10pt;" class="">-----Ursprüngliche
                                  Nachricht-----<br class="">
                                  <span class=""><strong class="">Von:</strong>
                                    <a class="moz-txt-link-abbreviated"
href="mailto:Heine.Thomas@online.de" moz-do-not-send="true">Heine.Thomas@online.de</a> <a
                                      class="moz-txt-link-rfc2396E"
                                      href="mailto:Heine.Thomas@online.de"
                                      moz-do-not-send="true"><Heine.Thomas@online.de></a></span><br
                                    class="">
                                  <span class=""><strong class="">Gesendet:</strong>
                                    Donnerstag 8 April 2021 08:24</span><br
                                    class="">
                                  <span class=""><strong class="">An:</strong>
                                    <a class="moz-txt-link-abbreviated"
href="mailto:volkszaehler-users@demo.volkszaehler.org"
                                      moz-do-not-send="true">volkszaehler-users@demo.volkszaehler.org</a></span><br
                                    class="">
                                  <span class=""><strong class="">Betreff:</strong>
                                    Re: [vz-users] Abfrage Zählerstand
                                    aus Wasserzähler</span><br class="">
                                  <br class="">
                                </span>
                                <div class="bodyclass">Hallo Andreas,<br
                                    class="">
                                  <br class="">
                                  es liegen seid 2.4. Daten vor
                                  (inzwischen 1450 Liter)<br class="">
                                  Initialverbrauch 134264 Liter<br
                                    class="">
                                  Der Zählerstand sollten also
                                  inzwischen rechnerisch 135714 Liter
                                  sein.<br class="">
                                  <br class="">
                                  Hier die Debug-Abfrage:<br class="">
                                  <br class="">
                                  <a
href="http://192.168.178.51/data/xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json?from=-1&options=raw&debug=1"
title="http://192.168.178.51/data/xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json?from=-1&options=raw&debug=1
                                    Klicken Sie auf den Link, um die URL
                                    in einem neuen Fenster zu öffnen."
                                    rel="noreferrer noopener"
                                    target="_blank"
                                    moz-do-not-send="true" class="">http://192.168.178.51/data/xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx.json?from=-1&options=raw&debug=1</a><br
                                    class="">
                                  <br class="">
                                  und das Ergebnis:<br class="">
                                  <br class="">
                                  <pre class="data">{
        "version": "0.3",
        "data": {
                "tuples": [
                        [
                                1617862067814,<span class="red-ui-debug-msg-payload"><span class="red-ui-debug-msg-element red-ui-debug-msg-top-level"><span class="red-ui-debug-msg-row"><span class="red-ui-debug-msg-object-value"><span class="red-ui-debug-msg-type-number red-ui-debug-msg-type-number-toggle">1617864302904</span></span></span></span></span>
                                145,
                                1
                        ]
                ],
                "uuid": "xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx",
                "from": 1617861767833,
                "to": 1617862067814,
                "average": 0,
                "consumption": 0,
                "rows": 2
        },
        "debug": {
                "database": "pdo_mysql",
                "time": 0.19783,
                "uptime": 1177360290,
                "load": [
                        3.78,
                        4.25,
                        4.21
                ],
                "commit-hash": "xxxxxxxxxxxxxxxxxxxxxxxxxxx",
                "php-version": "7.3.19-1~deb10u1",
                "messages": [],
                "sql": {
                        "totalTime": 0.02234506607055664,
                        "worstTime": 0.0026459693908691406,
                        "queries": [
                                {
                                        "sql": "SELECT \n  MAX(timestamp) \nFROM \n  data \nWHERE \n  channel_id = 44 \n  AND timestamp < 1617873106000",
                                        "execTime": 0.0026459693908691406
                                },
                                {
                                        "sql": "SELECT \n  MAX(timestamp) \nFROM \n  data \nWHERE \n  channel_id = 44 \n  AND timestamp < 1617862067814",
                                        "execTime": 0.0012600421905517578
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 6 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.0021820068359375
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 5 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.0018649101257324219
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 4 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.002110004425048828
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 3 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.0017001628875732422
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 2 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.001873016357421875
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 1 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.0018138885498046875
                                },
                                {
                                        "sql": "SELECT \n  UNIX_TIMESTAMP(\n    FROM_UNIXTIME(\n      MIN(timestamp) \/ 1000, \n      \"%Y-%m-%d %H:%i:00\"\n    )\n  ) * 1000 \nFROM \n  aggregate \nWHERE \n  channel_id = 44 \n  AND type = '1' \n  AND timestamp >= UNIX_TIMESTAMP(\n    DATE_ADD(\n      FROM_UNIXTIME(\n        1617861767833 \/ 1000, \"%Y-%m-%d %H:%i:00\"\n      ), \n      INTERVAL 1 minute\n    )\n  ) * 1000",
                                        "execTime": 0.001316070556640625
                                },
                                {
                                        "sql": "SELECT \n  UNIX_TIMESTAMP(\n    DATE_ADD(\n      FROM_UNIXTIME(\n        MAX(timestamp) \/ 1000, \n        \"%Y-%m-%d %H:%i:00\"\n      ), \n      INTERVAL 1 minute\n    )\n  ) * 1000 \nFROM \n  aggregate \nWHERE \n  channel_id = 44 \n  AND type = '1' \n  AND timestamp < 1617862067814",
                                        "execTime": 0.0012249946594238281
                                },
                                {
                                        "sql": "SELECT \n  aggregate.type \nFROM \n  aggregate \n  INNER JOIN entities ON aggregate.channel_id = <a href="http://entities.id/" class="" moz-do-not-send="true">entities.id</a> \nWHERE \n  uuid = 'xxxxxx-xxxxx-xxxxx-xxxxx-xxxxxxxxxx' \n  and aggregate.type = 0 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nLIMIT \n  1",
                                        "execTime": 0.0016429424285888672
                                },
                                {
                                        "sql": "SELECT \n  COUNT(1) \nFROM \n  data \nWHERE \n  channel_id = 44 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814",
                                        "execTime": 0.001310110092163086
                                },
                                {
                                        "sql": "SELECT \n  timestamp, \n  value, \n  1 AS count \nFROM \n  data \nWHERE \n  channel_id = 44 \n  AND timestamp >= 1617861767833 \n  AND timestamp <= 1617862067814 \nORDER BY \n  timestamp ASC",
                                        "execTime": 0.0014009475708007812
                                }
                        ]
                }
        }
}</pre>
                                  <br class="">
                                  <br class="">
                                  Hilft das weiter?<br class="">
                                  <br class="">
                                  Gruß<br class="">
                                  Thomas<br class="">
                                  <br class="">
                                  <br class="">
                                  <br class="">
                                  <br class="">
                                  <br class="">
                                  <div class="moz-cite-prefix">Am
                                    08.04.2021 um 08:10 schrieb Andreas
                                    Goetz:<br class="">
                                  </div>
                                  <blockquote
                                    cite="mid:A1BC3B90-AE35-4DFC-9135-9BBF09FBE334@gmail.com"
                                    class="">
                                    <div dir="ltr" class="">Häng mal
                                      bitte ein &debug=1 dran, dann
                                      sollten wir sehen welches SQL
                                      ausgeführt wird. Vielleicht gibt
                                      das einen Hinweis.</div>
                                    <div dir="ltr" class=""><br class="">
                                    </div>
                                    <div dir="ltr" class="">Viele Grüße,
                                      Andreas</div>
                                    <div dir="ltr" class=""><br class="">
                                    </div>
                                    <div dir="ltr" class="">PS.: seit
                                      wann erfasst Du die Daten?</div>
                                    <div dir="ltr" class=""><br class="">
                                      <blockquote class="">Am 08.04.2021
                                        um 07:59 schrieb <a
                                          href="mailto:Heine.thomas@online.de"
title="mailto:Heine.thomas@online.de Klicken Sie auf den Link, um die
                                          URL in einem neuen Fenster zu
                                          öffnen." rel="noreferrer
                                          noopener" target="_blank"
                                          moz-do-not-send="true"
                                          class="">Heine.thomas@online.de</a>:<br
                                          class="">
                                        <br class="">
                                      </blockquote>
                                    </div>
                                    <blockquote class="">
                                      <div dir="ltr" class=""> Hallo,<br
                                          class="">
                                        <br class="">
                                        ich habe inzwischen meinen
                                        Wasserzähler mit einem
                                        Reed-Kontakt ausgestattet und
                                        lese ihn per Tasmota ESP8266
                                        über einen Counter
                                        (10l-Schritte) aus.<br class="">
                                        der Counterwert wird also alle
                                        10l um 1 erhöht.<br class="">
                                        Im VZ-Logger habe ich einen
                                        Kanal mit "Wasser Zählerstände"
                                        angelegt.<br class="">
                                        Das klappt soweit auch alles.
                                        Ich sehe einen Verbrauch, und
                                        auch den Gesamt-Zählerstand nach
                                        dem ich einen Initialen
                                        Zählerstand eingetragen habe.<br
                                          class="">
                                        <br class="">
                                        <div class=""><adillmbjlmnoplia.png></div>
                                        <br class="">
                                        <br class="">
                                        <br class="">
                                        Per HTTP-Request kann ich auch
                                        bestimmte Zeit-Bereiche super
                                        abfragen.<br class="">
                                        <br class="">
                                        Jetzt würde ich gerne aber an
                                        meiner Haus-Visualisierung den
                                        aktuellen Zählerstand anzeigen.<br
                                          class="">
                                        <br class="">
                                        <br class="">
                                        So wollte ich ihn abfragen:<br
                                          class="">
                                        <br class="">
                                        <a
href="http://192.168.178.51/data/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx.json?from=-1&options=raw"
title="http://192.168.178.51/data/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx.json?from=-1&options=raw
                                          Klicken Sie auf den Link, um
                                          die URL in einem neuen Fenster
                                          zu öffnen." rel="noreferrer
                                          noopener" target="_blank"
                                          moz-do-not-send="true"
                                          class="">http://192.168.178.51/data/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx.json?from=-1&options=raw</a><br
                                          class="">
                                        <br class="">
                                        das json sieht jedoch dann so
                                        aus:<br class="">
                                        <pre class="data">{"version":"0.3","data":{"tuples":[[1617860867741,144,1]],"uuid":"xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxx","from":1617860567724,"to":1617860867741,"average":0,"consumption":0,"rows":2}}</pre>
                                        <br class="">
                                        bzw. so:<br class="">
                                        <div class=""><lcnmkochlddnejkg.png></div>
                                        <br class="">
                                        der Zählerstand müsste derzeit
                                        irgendwo bei 136xxx Liter
                                        sein...<br class="">
                                        <br class="">
                                        Was mache ich bei der Abfrage
                                        zum Zählerstand falsch?<br
                                          class="">
                                        <br class="">
                                        Danke vorab für eure Hilfe<br
                                          class="">
                                        <br class="">
                                        Gruß<br class="">
                                        Thomas<br class="">
                                      </div>
                                    </blockquote>
                                  </blockquote>
                                  <br class="">
                                </div>
                              </blockquote>
                              <!-- end sanitized html --> </blockquote>
                            <br class="">
                          </div>
                        </div>
                      </blockquote>
                    </div>
                    <br class="">
                  </div>
                </blockquote>
                <br class="">
              </div>
            </div>
          </blockquote>
        </div>
        <br class="">
      </div>
    </blockquote>
    <br>
  </body>
</html>