# Query from Influxdb

**URL:** <https://discourse.nodered.org/t/query-from-influxdb/84987>\
**Category:** General\
**Tags:** database\
**Created:** [28 January 2024 12:19 UTC](https://discourse.nodered.org/t/query-from-influxdb/84987 "2024-01-28T12:19:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Astroman](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@Astroman](https://discourse.nodered.org/u/Astroman)\
**Post date:** [28 January 2024 12:19 UTC](https://discourse.nodered.org/t/query-from-influxdb/84987/1 "2024-01-28T12:19:32Z")

</div>

Hi friends. I need your supports.

I'm trying to get data from Influx Cloud DB.

Table influxdb:

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

I use influxdb in node[v2.0] due to "influxdb cloud".

Contain node like below.

from(bucket: "NodeRed")  
|\> range(start: -1s)  
|\> filter(fn: (r) =\> r["\_measurement"] == "myData" and r["\_field"] == "Makine" and r["\_value"] == "M3")  
|\> sort(columns: ["\_time"], desc: true)  
|\> limit(n: 1)

But it's not useful. After debugging in nodered, rows containing M2 and M3 are also coming. I want to get only the last row containing the M3 value from Influxdb.

In addition I cannot use below query with influxdb in node[v2.0]. I think v2.0 only works with flux query.

"SELECT \*  
FROM "myData"  
WHERE  
("Makine" == 'M3')  
order by timestamp desc  
limit 1"

1- How can I get contain M3 last row with flux query?  
2- Is there alternative using above SQL query in nodered?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [28 January 2024 13:53 UTC](https://discourse.nodered.org/t/query-from-influxdb/84987/2 "2024-01-28T13:53:27Z")

</div>

I believe that Makine must be a tag (not a field) then you can Group by it to select just the ones you want.

---

<div class="post-metadata">

**Author:** ![Astroman](https://avatars.discourse-cdn.com/v4/letter/a/b782af/32.png) [@Astroman](https://discourse.nodered.org/u/Astroman)\
**Post date:** [28 January 2024 19:03 UTC](https://discourse.nodered.org/t/query-from-influxdb/84987/3 "2024-01-28T19:03:42Z")

</div>

Hi Colin. Thanks for your idea.

The following query solved my problem.

As in SQL, it returns last complete row containing M3.

from(bucket: "NodeRED")  
|\> range(start: -1m)  
|\> filter(fn: (r) =\> r["\_measurement"] == "myData")  
|\> pivot(rowKey: ["\_time"], columnKey: ["\_field"], valueColumn: "\_value")  
|\> filter(fn:(r) =\> r.Makine == "M3")  
|\> limit(n:1)

---

<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 February 2024 19:04 UTC](https://discourse.nodered.org/t/query-from-influxdb/84987/4 "2024-02-11T19:04:29Z")

</div>

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