# Consultar datos de influxdb para calcular tiempos

**URL:** <https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190>\
**Category:** General\
**Created:** [17 February 2021 19:15 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190 "2021-02-17T19:15:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![novato1221](https://avatars.discourse-cdn.com/v4/letter/n/e19b73/32.png) [@novato1221](https://discourse.nodered.org/u/novato1221)\
**Post date:** [17 February 2021 19:15 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190/1 "2021-02-17T19:15:11Z")

</div>

Hola a todos, estoy aprendiendo ahora mismo Node-red y influxdb. Tengo un proyecto en influxdb donde consulto o leo datos de influxdb db. La consulta que estoy haciendo es la siguiente:  
msg.query = "select time,estado from measurements where nombremaquina = 'm1'"+ msg.payload;

Con los datos consultados tengo que mostrarlos en Dashboard y además calcular el tiempo que m1 ha estado en funcionamiento o parada.

Un saludo

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [17 February 2021 19:31 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190/2 "2021-02-17T19:31:11Z")

</div>

Pure guess - try...

```auto
var clause = "m1" + msg.payload;
msg.query = `select time,estado from measurements where nombremaquina = '${clause}'`;

```

---

<div class="post-metadata">

**Author:** ![novato1221](https://avatars.discourse-cdn.com/v4/letter/n/e19b73/32.png) [@novato1221](https://discourse.nodered.org/u/novato1221)\
**Post date:** [18 February 2021 15:25 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190/3 "2021-02-18T15:25:48Z")

</div>

Pero como uso los datos de la consulta en otra función para mostrarlos en Dashboard?  
Gracias

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [18 February 2021 15:57 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190/4 "2021-02-18T15:57:31Z")

</div>

> [@novato1221](#):
>
> Pero como uso los datos de la consulta en otra función para mostrarlos en Dashboard?

Learn node red.

Example: [InfluxDB with Node-Red – Fun Tech Projects](https://funprojects.blog/2020/02/01/influxdb-with-node-red/)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [19 April 2021 15:58 UTC](https://discourse.nodered.org/t/consultar-datos-de-influxdb-para-calcular-tiempos/41190/5 "2021-04-19T15:58:13Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.