Gauge field from Mysql table

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.

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}}

I don't have the value format field.

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

thanks friend gauge worked very well.

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