# Gauge field from Mysql table

**URL:** <https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125>\
**Category:** General\
**Created:** [2 May 2023 19:44 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125 "2023-05-02T19:44:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bertifox](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bertifox/32/79482_2.png) [@Bertifox](https://discourse.nodered.org/u/Bertifox)\
**Post date:** [2 May 2023 19:44 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/1 "2023-05-02T19:44:30Z")

</div>

Dear forum members, I need someone to help me with node red v3.02, I need to graph with gauge a field called Temperature from a mysql table as this field is referenced in gauge node.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [2 May 2023 20:09 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/2 "2023-05-02T20:09:37Z")

</div>

Add a debug to the sql node, then use the copy path icon/button, it appears when you hover the mouse over property name. Copy the path to the value you want to display. Then in the gauge node use `{{msg.copied_path}}` in the value format field.  
You should end up with something like `{{msg.payload[0].Temperature}}`

---

<div class="post-metadata">

**Author:** ![Bertifox](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bertifox/32/79482_2.png) [@Bertifox](https://discourse.nodered.org/u/Bertifox)\
**Post date:** [2 May 2023 21:19 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/3 "2023-05-02T21:19:04Z")

</div>

> [@E1cid](#):
>
> value format field.

I don't have the value format field.

 ![NodeRED](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/2/221383b6f9ab093e42f1ad39a8f3d2223cb3a046.jpeg)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [2 May 2023 21:25 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/4 "2023-05-02T21:25:25Z")

</div>

With the limited info you gave i assumed you meant ui-gauge. Use the copied path in the input field of the artless gauge.

---

<div class="post-metadata">

**Author:** ![Bertifox](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bertifox/32/79482_2.png) [@Bertifox](https://discourse.nodered.org/u/Bertifox)\
**Post date:** [2 May 2023 23:37 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/5 "2023-05-02T23:37:34Z")

</div>

thanks friend gauge worked very well.

---

<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:** [1 July 2023 23:38 UTC](https://discourse.nodered.org/t/gauge-field-from-mysql-table/78125/6 "2023-07-01T23:38:10Z")

</div>

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