# Recorrer consulta influxdb

**URL:** <https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620>\
**Category:** General\
**Created:** [25 February 2021 13:12 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620 "2021-02-25T13:12:43Z")\
**Posts on this page:** 6\
**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:** [25 February 2021 13:12 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/1 "2021-02-25T13:12:43Z")

</div>

![Captura](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/a/6a36de9f0953b7cce9794ccdac32431a75d1747e.jpeg) ![Captura1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/1/d1b2f1ed3f04014f70f3221be8c1d1a435dfe7a9.jpeg) ![Captura2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/a/1a72428e87f0c91d4dbcae6d28c8c6129df53de5.jpeg)

Estoy realizando ese programa pero me aparece el siguiente error en la segunda función:  
TypeError: Cannot read property 'time' of undefined ![Captura3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/6/46f21ed4544adc291e32576a71612cc6682b74ad.jpeg)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [25 February 2021 13:50 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/3 "2021-02-25T13:50:37Z")

</div>

> [@novato1221](#):
>
> ‎I'm doing that program but I get the following error in the second function‎

The error says that it cannot get the `time` property because the specified parent does not exist.

Look through your code for lines that have `.time`. I note that they appear in a loop. Specifically, you are using a loop counter as an array index but you are using `i+1` - so on the last iteration of the loop, that reference won't exist.

---

<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:** [25 February 2021 14:02 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/4 "2021-02-25T14:02:50Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/a/fa5edd58424aa8e4bb283b577d251fccd1eeb5d2.png)

should be `for(let i=0; i < msg.payload.length-1; i++)`

---

<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:** [25 February 2021 18:25 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/5 "2021-02-25T18:25:01Z")

</div>

Gracias ahora me crea el nuevo measurements pero hay un tipo de dato NaN ![Captura5](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/b/9b5c91959e45ce0b96722a2eb084c5970a066d26.jpeg)

---

<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:** [25 February 2021 19:14 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/6 "2021-02-25T19:14:12Z")

</div>

> [@novato1221](#):
>
> pero hay un tipo de dato NaN

That will be because of a bad value in planificado or tiempoparo

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/a/3a4a19a50a987cf0a034d03a9918a0a57fec2036.png)

add these

```auto
//...
node.warn(planificado); //<<<< additional linea
node.warn(tiempoparo); //<<<< additional linea
disponibilidad = (planificado-tiempoparo)/planificado;
//...

```

---

<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:** [11 March 2021 19:14 UTC](https://discourse.nodered.org/t/recorrer-consulta-influxdb/41620/7 "2021-03-11T19:14:41Z")

</div>

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