# Latest

**URL:** https://discourse.nodered.org/latest.md?page=755

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 756

---

## [Better way to parse JSON?](https://discourse.nodered.org/t/better-way-to-parse-json/49579)

<div class="topic-metadata">

**Author:** [@Xeniluom](https://discourse.nodered.org/u/Xeniluom)\
**Replies:** 2\
**Last updated:** [10 August 2021 20:19 UTC](https://discourse.nodered.org/t/better-way-to-parse-json/49579 "2021-08-10T20:19:03Z")

</div>

Hi, in a previous post I ask how to find all global variable and it's works perfectly. (List of all global) the JSON i receive is like this : { "payload": \[ { "maison/bureau/temperature": "26.3…

---

## [Get data from barcode](https://discourse.nodered.org/t/get-data-from-barcode/49550)

<div class="topic-metadata">

**Author:** [@JesusGr](https://discourse.nodered.org/u/JesusGr)\
**Replies:** 6\
**Last updated:** [10 August 2021 19:01 UTC](https://discourse.nodered.org/t/get-data-from-barcode/49550 "2021-08-10T19:01:03Z")

</div>

Hi everyone! I've been trying to read data from a barcode and print it on a debug node, but it just doesn't print anything. I've the barcode reader connected by USB port to a raspberry pi 4. The reader is configured fo…

---

## [Admin portal / node-red-contrib-users: How to expire session?](https://discourse.nodered.org/t/admin-portal-node-red-contrib-users-how-to-expire-session/49384)

<div class="topic-metadata">

**Author:** [@JDN](https://discourse.nodered.org/u/JDN)\
**Replies:** 1\
**Last updated:** [10 August 2021 18:48 UTC](https://discourse.nodered.org/t/admin-portal-node-red-contrib-users-how-to-expire-session/49384 "2021-08-10T18:48:58Z")

</div>

Does anyone have an idea how the sessions of a user being logged in via the admin portal or via the contrib-users node could be limited to a certain period, i.e. how to realize an "auto-logout", maybe via setting an expi…

---

## [Forum Unformatted code detector plugin enabled](https://discourse.nodered.org/t/forum-unformatted-code-detector-plugin-enabled/49577)

<div class="topic-metadata">

**Author:** [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Replies:** 0\
**Last updated:** [10 August 2021 16:27 UTC](https://discourse.nodered.org/t/forum-unformatted-code-detector-plugin-enabled/49577 "2021-08-10T16:27:59Z")

</div>

A while ago we tried the Unformatted Code detector plugin in the forum. This would try to spot if a user was posting code that wasn't properly formatted and help them fix it. At the time, it wasn't detecting single-line…

---

## [List of all global](https://discourse.nodered.org/t/list-of-all-global/49567)

<div class="topic-metadata">

**Author:** [@Xeniluom](https://discourse.nodered.org/u/Xeniluom)\
**Replies:** 7\
**Last updated:** [10 August 2021 15:53 UTC](https://discourse.nodered.org/t/list-of-all-global/49567 "2021-08-10T15:53:59Z")

</div>

Hi, I am looking for a method to retrieve the name of the global variables as well as their value. For the moment, I only manage to have an array with the values: global.get (global.keys ()) I can't get the name of t…

---

## [Global Variable to format Value/Label fields of ui-nodes](https://discourse.nodered.org/t/global-variable-to-format-value-label-fields-of-ui-nodes/49572)

<div class="topic-metadata">

**Author:** [@jodelkoenig](https://discourse.nodered.org/u/jodelkoenig)\
**Replies:** 3\
**Last updated:** [10 August 2021 15:51 UTC](https://discourse.nodered.org/t/global-variable-to-format-value-label-fields-of-ui-nodes/49572 "2021-08-10T15:51:01Z")

</div>

I use HTML to format Value Format and Label of UI-nodes. F. e. \<font color = {{msg.color}} \>Hallo\</font\> msg.color is defined right before the ui-node in the corresponding flows. I thought, I could globally set my col…

---

## [Build custom node using C++ DLL](https://discourse.nodered.org/t/build-custom-node-using-c-dll/49527)

<div class="topic-metadata">

**Author:** [@FiloCara](https://discourse.nodered.org/u/FiloCara)\
**Replies:** 4\
**Last updated:** [10 August 2021 13:43 UTC](https://discourse.nodered.org/t/build-custom-node-using-c-dll/49527 "2021-08-10T13:43:14Z")

</div>

Hello, Newbie question here. I would like to build a custom node to get images from a thermal camera directly in Node-Red. In order to do that I need to create a NodeJS wrapper to a C++ DLL available in the camera SDK.…

---

## [Count Messages - Reset externally](https://discourse.nodered.org/t/count-messages-reset-externally/49560)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 3\
**Last updated:** [10 August 2021 10:24 UTC](https://discourse.nodered.org/t/count-messages-reset-externally/49560 "2021-08-10T10:24:00Z")

</div>

@Steve-Mcl Hi, is there a way to reset the function code externally, for example, by clicking inject 0, the count should reset

---

## [Address unreachable](https://discourse.nodered.org/t/address-unreachable/49205)

<div class="topic-metadata">

**Author:** [@fredshortlv129bis](https://discourse.nodered.org/u/fredshortlv129bis)\
**Replies:** 6\
**Last updated:** [10 August 2021 09:30 UTC](https://discourse.nodered.org/t/address-unreachable/49205 "2021-08-10T09:30:44Z")

</div>

What can i do with these message? http://192.168.0.129:1880/#flow/cb6f77f6.8fa118 is niet bereikbaar. ERR\_ADDRESS\_UNREACHABLE Do I lost my flow? Jack

---

## [Read data from a table](https://discourse.nodered.org/t/read-data-from-a-table/49518)

<div class="topic-metadata">

**Author:** [@anguslou](https://discourse.nodered.org/u/anguslou)\
**Replies:** 5\
**Last updated:** [10 August 2021 09:08 UTC](https://discourse.nodered.org/t/read-data-from-a-table/49518 "2021-08-10T09:08:41Z")

</div>

I want to make a table on dashboard and allow user to input simple data such as dimension of boxes, eg, Length Width Height Box 1 20 12 7 Box 2 23 …

---

## [MsSQL unique data Dropdown](https://discourse.nodered.org/t/mssql-unique-data-dropdown/49545)

<div class="topic-metadata">

**Author:** [@sefaguntepe](https://discourse.nodered.org/u/sefaguntepe)\
**Replies:** 11\
**Last updated:** [10 August 2021 09:07 UTC](https://discourse.nodered.org/t/mssql-unique-data-dropdown/49545 "2021-08-10T09:07:50Z")

</div>

I want to filter on date column in database. Then I want to show the sensor names that will come from here in the dropdown. (uniquely). Here's what I can do f1 start='2021-08-01' end='2021-08-05' msg.payload ="SELECT…

---

## [Broken Node-red after update](https://discourse.nodered.org/t/broken-node-red-after-update/49499)

<div class="topic-metadata">

**Author:** [@win7viena](https://discourse.nodered.org/u/win7viena)\
**Replies:** 10\
**Last updated:** [10 August 2021 07:02 UTC](https://discourse.nodered.org/t/broken-node-red-after-update/49499 "2021-08-10T07:02:14Z")

</div>

Hello I ask you to please help with the problem, I have very old-ubuntu machine with node-red, node-red dashboard and other plugins. First of all my pc running on Ubuntu 17.10 (GNU/Linux 4.13.0-46-generic x86\_64) nod…

---

## [How to push Node-Red to GitHub without revealing sensitive information?](https://discourse.nodered.org/t/how-to-push-node-red-to-github-without-revealing-sensitive-information/49505)

<div class="topic-metadata">

**Author:** [@portfedh](https://discourse.nodered.org/u/portfedh)\
**Replies:** 6\
**Last updated:** [10 August 2021 02:51 UTC](https://discourse.nodered.org/t/how-to-push-node-red-to-github-without-revealing-sensitive-information/49505 "2021-08-10T02:51:40Z")

</div>

I would like to share my NodeRed Code in Github as part of an IOT project, however I would like to keep some of my data private (MQTT password, InfluxDB password, etc). I could manually erase this information, but this …

---

## [Select from Mysql](https://discourse.nodered.org/t/select-from-mysql/49446)

<div class="topic-metadata">

**Author:** [@zamzon](https://discourse.nodered.org/u/zamzon)\
**Replies:** 15\
**Last updated:** [9 August 2021 21:07 UTC](https://discourse.nodered.org/t/select-from-mysql/49446 "2021-08-09T21:07:45Z")

</div>

Hi I need to get data from my sql database, but i can't see how to get the newest values. my database looks like this I need all the newest ballast state based on an Area

---

## [Node-Red stopped... sort of](https://discourse.nodered.org/t/node-red-stopped-sort-of/49424)

<div class="topic-metadata">

**Author:** [@tony1](https://discourse.nodered.org/u/tony1)\
**Replies:** 16\
**Last updated:** [9 August 2021 20:57 UTC](https://discourse.nodered.org/t/node-red-stopped-sort-of/49424 "2021-08-09T20:57:00Z")

</div>

I have Node-Red 0.18.4 running under NSSM. A few days ago it stopped mysteriously, and we became aware because it stopped logging to MSSQL. However, I could still see the project through the web editor. New error message…

---

## [\[ANNOUNCE\] node-red-contrib-ui-countdown-timer-switch](https://discourse.nodered.org/t/announce-node-red-contrib-ui-countdown-timer-switch/38526)

<div class="topic-metadata">

**Author:** [@fellinga](https://discourse.nodered.org/u/fellinga)\
**Replies:** 28\
**Last updated:** [9 August 2021 20:51 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-ui-countdown-timer-switch/38526 "2021-08-09T20:51:27Z")

</div>

Ui Countdown Timer Switch It's always nice to automate things but sometimes automation needs some flexibility that can be triggered manually. I've created a UI node that is basically a simple switch but displays the tim…

---

## [Ui-table: highlight updated cells with animations](https://discourse.nodered.org/t/ui-table-highlight-updated-cells-with-animations/49333)

<div class="topic-metadata">

**Author:** [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)\
**Replies:** 2\
**Last updated:** [9 August 2021 20:36 UTC](https://discourse.nodered.org/t/ui-table-highlight-updated-cells-with-animations/49333 "2021-08-09T20:36:41Z")

</div>

This only works if you update your ui-table by commands! I researched a while to get my tables show dynamic updates of cells visually: In the end the solution is quite simple. A template node to define your css anim…

---

## [Node-Red Library - new version not available in palette](https://discourse.nodered.org/t/node-red-library-new-version-not-available-in-palette/49508)

<div class="topic-metadata">

**Author:** [@hklages](https://discourse.nodered.org/u/hklages)\
**Replies:** 5\
**Last updated:** [9 August 2021 19:34 UTC](https://discourse.nodered.org/t/node-red-library-new-version-not-available-in-palette/49508 "2021-08-09T19:34:55Z")

</div>

Yesterday I created a new release 5.2.5 of my custom node node-red-contrib-sonos-plus. It shows up in github, npm and also Node-RED library. But it does NOT show up in the palette of my installations in Docker/ and Hom…

---

## [Create Chart from mySQL Data](https://discourse.nodered.org/t/create-chart-from-mysql-data/3296)

<div class="topic-metadata">

**Author:** [@neophilipp](https://discourse.nodered.org/u/neophilipp)\
**Replies:** 36\
**Last updated:** [9 August 2021 19:07 UTC](https://discourse.nodered.org/t/create-chart-from-mysql-data/3296 "2021-08-09T19:07:57Z")

</div>

Hello Pro's, need to create a chart with the following data from mySQL table: db name: sensors table name: temperature | 1\_OWD | 2493 | 2018-09-20 09:17:32 | | 1\_OWD | 2493 | 2018-09-20 09:19:02 | | 1\_OWD | 25…

---

## [Making a Node-RED Project into hardware](https://discourse.nodered.org/t/making-a-node-red-project-into-hardware/49541)

<div class="topic-metadata">

**Author:** [@RafaelMarquesRibeiro](https://discourse.nodered.org/u/RafaelMarquesRibeiro)\
**Replies:** 1\
**Last updated:** [9 August 2021 18:46 UTC](https://discourse.nodered.org/t/making-a-node-red-project-into-hardware/49541 "2021-08-09T18:46:56Z")

</div>

Greetings! I'm a Mechanical Engineering student that is currently an intern in a company. I´ve self-proposed a project of a semi-automatic counter to replace the old pen and paper system that they are currently using. M…

---

## [Context Question](https://discourse.nodered.org/t/context-question/49542)

<div class="topic-metadata">

**Author:** [@nacartwright](https://discourse.nodered.org/u/nacartwright)\
**Replies:** 1\
**Last updated:** [9 August 2021 18:11 UTC](https://discourse.nodered.org/t/context-question/49542 "2021-08-09T18:11:38Z")

</div>

We're working on making an API for chatbots. When you set the flow context I understand that is stored in memory. Does that means if you set the flow context on one http post it can be read on the next?

---

## [How to combine date and time picker get data mysql](https://discourse.nodered.org/t/how-to-combine-date-and-time-picker-get-data-mysql/49524)

<div class="topic-metadata">

**Author:** [@Apoki21](https://discourse.nodered.org/u/Apoki21)\
**Replies:** 4\
**Last updated:** [9 August 2021 17:27 UTC](https://discourse.nodered.org/t/how-to-combine-date-and-time-picker-get-data-mysql/49524 "2021-08-09T17:27:53Z")

</div>

Hello Guys I Need help, i have promblem generate csv file get mysql this my flow: and this my function combine: This my dashboard grab: This my format datetime on mysql Thanks All

---

## [How to detect a 0-1-0 and then a 1-0-1 sequence](https://discourse.nodered.org/t/how-to-detect-a-0-1-0-and-then-a-1-0-1-sequence/49534)

<div class="topic-metadata">

**Author:** [@Charry2014](https://discourse.nodered.org/u/Charry2014)\
**Replies:** 4\
**Last updated:** [9 August 2021 17:12 UTC](https://discourse.nodered.org/t/how-to-detect-a-0-1-0-and-then-a-1-0-1-sequence/49534 "2021-08-09T17:12:34Z")

</div>

Hello everyone, I have a garage door sensor that when the door opens is emits a 1-0-1 sequence of events in about 2 seconds, then when it closes the inverse 0-1-0. A steady 0 means the door is closed, a steady 1 means th…

---

## [InfluxDB update issue](https://discourse.nodered.org/t/influxdb-update-issue/49539)

<div class="topic-metadata">

**Author:** [@davidz](https://discourse.nodered.org/u/davidz)\
**Replies:** 3\
**Last updated:** [9 August 2021 16:47 UTC](https://discourse.nodered.org/t/influxdb-update-issue/49539 "2021-08-09T16:47:30Z")

</div>

This post is a friendly reminder that InfluxDB 1.8.7-1.8.9 release has start issue. We recently updated a few devices running Node-RED and InfluxDB and there are data review error. It turned out that InfluxDB did not st…

---

## [UI Button Colour from Global variable](https://discourse.nodered.org/t/ui-button-colour-from-global-variable/49538)

<div class="topic-metadata">

**Author:** [@MyRandomThoughts](https://discourse.nodered.org/u/MyRandomThoughts)\
**Replies:** 0\
**Last updated:** [9 August 2021 15:24 UTC](https://discourse.nodered.org/t/ui-button-colour-from-global-variable/49538 "2021-08-09T15:24:15Z")

</div>

I currently set a global variable with all the colours required for my buttons. I set this at startup and have a LinkIn node attached to the buttons with {{colour.xxxx}} as the text and background colours. This mostly …

---

## [OPC UA Alarams can be generated using node-red interface!](https://discourse.nodered.org/t/opc-ua-alarams-can-be-generated-using-node-red-interface/49537)

<div class="topic-metadata">

**Author:** [@oualid](https://discourse.nodered.org/u/oualid)\
**Replies:** 0\
**Last updated:** [9 August 2021 14:56 UTC](https://discourse.nodered.org/t/opc-ua-alarams-can-be-generated-using-node-red-interface/49537 "2021-08-09T14:56:22Z")

</div>

hi node-red community, i want to know if it's possible to generate a fake opc ua alarm using node-red node. i already succeeded to create manually, with java Script, an opcua server and generate alarms but i want to do…

---

## [Getting value of DOCUMENT\_ROOT from PHP](https://discourse.nodered.org/t/getting-value-of-document-root-from-php/49504)

<div class="topic-metadata">

**Author:** [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Replies:** 9\
**Last updated:** [9 August 2021 10:41 UTC](https://discourse.nodered.org/t/getting-value-of-document-root-from-php/49504 "2021-08-09T10:41:58Z")

</div>

I'm running PHP on nginx (on a RPi-4B) that is also running Node-RED. Is there a way to get hold of... $\_SERVER\['DOCUMENT\_ROOT'\] and use it within Node-RED ?? e.g. like executing \<?php echo $\_SERVER\['DOCUMENT\_ROOT'\]; ?\>…

---

## [Dashboard - Multi User Login System Flow Example](https://discourse.nodered.org/t/dashboard-multi-user-login-system-flow-example/49301)

<div class="topic-metadata">

**Author:** [@meeki007](https://discourse.nodered.org/u/meeki007)\
**Replies:** 3\
**Last updated:** [9 August 2021 13:03 UTC](https://discourse.nodered.org/t/dashboard-multi-user-login-system-flow-example/49301 "2021-08-09T13:03:33Z")

</div>

Dashboard - Multi User Login System Flow Example Demo - https://dashboard-muls.no-fs.com/ui/ Username=admin / Password=password Resets changes every hour so if someone messes it up just try agin in an hour. Requires n…

---

## [Reading Siemens S7 analog value](https://discourse.nodered.org/t/reading-siemens-s7-analog-value/49525)

<div class="topic-metadata">

**Author:** [@nrbrt](https://discourse.nodered.org/u/nrbrt)\
**Replies:** 1\
**Last updated:** [9 August 2021 12:08 UTC](https://discourse.nodered.org/t/reading-siemens-s7-analog-value/49525 "2021-08-09T12:08:44Z")

</div>

Hi, I am trying to read an analog input from the Siemens S7 1212C PLC. I can read and write the digital i/o just fine and I get the correct analog voltage to show in the Siemens TIA software with a norm\_x and scale\_x ins…

---

## [Csv with ibm cloud](https://discourse.nodered.org/t/csv-with-ibm-cloud/49528)

<div class="topic-metadata">

**Author:** [@erki338](https://discourse.nodered.org/u/erki338)\
**Replies:** 0\
**Last updated:** [9 August 2021 11:50 UTC](https://discourse.nodered.org/t/csv-with-ibm-cloud/49528 "2021-08-09T11:50:42Z")

</div>

Hello, im running my node red on ibm cloud and i would like download csv file from mysql but the problem right now is with ibm im not able to save csv file. Is there another way i can upload csv file and download it eas…

[Previous page](https://discourse.nodered.org/latest.md?page=754)

[Next page](https://discourse.nodered.org/latest.md?page=756)