# Latest

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

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

**Page:** 717

---

## [Loop query array and send to mysql](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 5\
**Last updated:** [14 October 2021 18:19 UTC](https://discourse.nodered.org/t/loop-query-array-and-send-to-mysql/52199 "2021-10-14T18:19:40Z")

</div>

I have array of query I try sent msg.topic to mysql like this but it send me only one query How to loop query as msg.topic and send to mysql ?

---

## [Enable projects on Windows10 with v2.0.6?](https://discourse.nodered.org/t/enable-projects-on-windows10-with-v2-0-6/52223)

<div class="topic-metadata">

**Author:** [@wb666greene](https://discourse.nodered.org/u/wb666greene)\
**Replies:** 7\
**Last updated:** [14 October 2021 18:06 UTC](https://discourse.nodered.org/t/enable-projects-on-windows10-with-v2-0-6/52223 "2021-10-14T18:06:30Z")

</div>

Taking a detour helping setup Windows 10 for a friend. Got node-red v2.0.6 running apparently correctly, but I don't see the "Projects" selection in the hamburger menu. I edited the settings file editorTheme: { proje…

---

## [Node-red-contrib-zigbee2mqtt join in a function](https://discourse.nodered.org/t/node-red-contrib-zigbee2mqtt-join-in-a-function/52221)

<div class="topic-metadata">

**Author:** [@tpbillund](https://discourse.nodered.org/u/tpbillund)\
**Replies:** 3\
**Last updated:** [14 October 2021 17:31 UTC](https://discourse.nodered.org/t/node-red-contrib-zigbee2mqtt-join-in-a-function/52221 "2021-10-14T17:31:58Z")

</div>

Hi If I have to Zigbee devices and i'm using a zigbee2mqtt "GET" node. one for each device, how can I then wire em to the same "Function" node and set up a message? atm. i'm using this to get the values I want from on…

---

## [Time stamp difference](https://discourse.nodered.org/t/time-stamp-difference/52216)

<div class="topic-metadata">

**Author:** [@Jonathan95](https://discourse.nodered.org/u/Jonathan95)\
**Replies:** 6\
**Last updated:** [14 October 2021 17:13 UTC](https://discourse.nodered.org/t/time-stamp-difference/52216 "2021-10-14T17:13:48Z")

</div>

Hi all, I have an inverter that has a last connection date which I want to compare with the current node red server time then be able to give the difference in hours/days/months/years(if applicable). I have tried both…

---

## [Retrieve an ENV variable label in subflow](https://discourse.nodered.org/t/retrieve-an-env-variable-label-in-subflow/52222)

<div class="topic-metadata">

**Author:** [@fmarzocca](https://discourse.nodered.org/u/fmarzocca)\
**Replies:** 2\
**Last updated:** [14 October 2021 16:16 UTC](https://discourse.nodered.org/t/retrieve-an-env-variable-label-in-subflow/52222 "2021-10-14T16:16:56Z")

</div>

Hi, I have set Lables on an env variable in a subflow (as a list), as shown: Now, I need to retrieve the Label in a function (in the same subflow), depending upon the choosen value. The env variable is named ACTION. …

---

## [HTTP Request - Persistent authorization token](https://discourse.nodered.org/t/http-request-persistent-authorization-token/52175)

<div class="topic-metadata">

**Author:** [@zuasive](https://discourse.nodered.org/u/zuasive)\
**Replies:** 7\
**Last updated:** [14 October 2021 14:22 UTC](https://discourse.nodered.org/t/http-request-persistent-authorization-token/52175 "2021-10-14T14:22:59Z")

</div>

Hello good people, I'm hoping for an assist here. I've been trying to get a flow working for some time now and keep hitting a road block. The goal is to be able to do a lookup on a separate REST service using 3 posts w/j…

---

## [Simplify function node](https://discourse.nodered.org/t/simplify-function-node/52172)

<div class="topic-metadata">

**Author:** [@Romprod](https://discourse.nodered.org/u/Romprod)\
**Replies:** 9\
**Last updated:** [14 October 2021 13:48 UTC](https://discourse.nodered.org/t/simplify-function-node/52172 "2021-10-14T13:48:05Z")

</div>

Hi, I have the following function node that I'm trying to simplify, instead of listing all array items is there a way to make it loop them? The number of array items may not always be the same. msg.payload = { "@t…

---

## [Editor width with Monaco](https://discourse.nodered.org/t/editor-width-with-monaco/52215)

<div class="topic-metadata">

**Author:** [@garrett](https://discourse.nodered.org/u/garrett)\
**Replies:** 0\
**Last updated:** [14 October 2021 13:28 UTC](https://discourse.nodered.org/t/editor-width-with-monaco/52215 "2021-10-14T13:28:03Z")

</div>

I absolutely love having the Monaco editor! One minor annoyance is the width of the editor box when I open a function - with ACE I could drag it larger and it would retain the size after that. With Monaco it defaults to …

---

## [Imported and deployed flow from the "Creating your first flow" tutorial produces "Invalid Date" in debug](https://discourse.nodered.org/t/imported-and-deployed-flow-from-the-creating-your-first-flow-tutorial-produces-invalid-date-in-debug/52210)

<div class="topic-metadata">

**Author:** [@ackalker](https://discourse.nodered.org/u/ackalker)\
**Replies:** 1\
**Last updated:** [14 October 2021 11:41 UTC](https://discourse.nodered.org/t/imported-and-deployed-flow-from-the-creating-your-first-flow-tutorial-produces-invalid-date-in-debug/52210 "2021-10-14T11:41:27Z")

</div>

As an experiment, I did a fresh install of Node-RED moved my existing $HOME/.node-red directory aside started Node-RED copied the flow at the bottom of the Creating your first flow tutorial imported the flow in Node-RE…

---

## [🎉 Node-RED 2.1.0-beta.1 released](https://discourse.nodered.org/t/node-red-2-1-0-beta-1-released/51963)

<div class="topic-metadata">

**Author:** [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Replies:** 15\
**Last updated:** [14 October 2021 12:38 UTC](https://discourse.nodered.org/t/node-red-2-1-0-beta-1-released/51963 "2021-10-14T12:38:35Z")

</div>

:tada: The first beta release of Node-RED 2.1.0 is now available. The Change Log has the full list of changes in this release, but here are the highlights. Note: if any issues are reported against the beta, we'll updat…

---

## [Node-red-contrib-mssql / Connection is closed](https://discourse.nodered.org/t/node-red-contrib-mssql-connection-is-closed/52188)

<div class="topic-metadata">

**Author:** [@sefaguntepe](https://discourse.nodered.org/u/sefaguntepe)\
**Replies:** 1\
**Last updated:** [14 October 2021 12:34 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-connection-is-closed/52188 "2021-10-14T12:34:17Z")

</div>

Hello, I have 12 flow. Each flow has one "MSSQL" node. I noticed recently that I was getting this error all the time. What do you think I should do? "ConnectionError: Connection is closed."

---

## [Reading the udp data with a frame header](https://discourse.nodered.org/t/reading-the-udp-data-with-a-frame-header/52161)

<div class="topic-metadata">

**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\
**Replies:** 11\
**Last updated:** [14 October 2021 12:26 UTC](https://discourse.nodered.org/t/reading-the-udp-data-with-a-frame-header/52161 "2021-10-14T12:26:34Z")

</div>

I'm receiving data from a Dragino temp sensor via a UDP node. The payload contains 25 bytes that i need to convert to string. According to Dragino, i have a frame definition i need to follow to i guess separate the byte…

---

## [Node-red-contrib-mssql-plus =\> value in database is empty](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205)

<div class="topic-metadata">

**Author:** [@Alexandre1987](https://discourse.nodered.org/u/Alexandre1987)\
**Replies:** 4\
**Last updated:** [14 October 2021 12:19 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205 "2021-10-14T12:19:05Z")

</div>

Processing: Nodered.pdf... Hello, I am a new user of Nodered and am starting to create my first flux. I am having difficulty with the "node-red-contrib-mssql-plus" node, I can connect to my table, a row is created but…

---

## [Search on webpage and retrieve data](https://discourse.nodered.org/t/search-on-webpage-and-retrieve-data/52091)

<div class="topic-metadata">

**Author:** [@Melliott](https://discourse.nodered.org/u/Melliott)\
**Replies:** 10\
**Last updated:** [14 October 2021 11:38 UTC](https://discourse.nodered.org/t/search-on-webpage-and-retrieve-data/52091 "2021-10-14T11:38:12Z")

</div>

Hi all. I'm looking to draw out information from my local council page, specifically bin collection data. Unfortunately to get that data requires a postcode to be entered before any of the data shows up. I've got a bas…

---

## [Node red ui builder with jquery?](https://discourse.nodered.org/t/node-red-ui-builder-with-jquery/52208)

<div class="topic-metadata">

**Author:** [@TomyT](https://discourse.nodered.org/u/TomyT)\
**Replies:** 1\
**Last updated:** [14 October 2021 10:45 UTC](https://discourse.nodered.org/t/node-red-ui-builder-with-jquery/52208 "2021-10-14T10:45:58Z")

</div>

Hello, I try to use jquery code inside my index.js file (using node red contrib uibuilder). But I always get an error if i use code like this: $('#container').hide(); The browser shows me: "Uncaught ReferenceError: $ …

---

## [Unable to uninstall a custom node](https://discourse.nodered.org/t/unable-to-uninstall-a-custom-node/51993)

<div class="topic-metadata">

**Author:** [@kakyoism](https://discourse.nodered.org/u/kakyoism)\
**Replies:** 8\
**Last updated:** [14 October 2021 07:43 UTC](https://discourse.nodered.org/t/unable-to-uninstall-a-custom-node/51993 "2021-10-14T07:43:46Z")

</div>

When I tried to uninstall a node, I got errors like this $ npm uninstall my\_proj npm WARN checkPermissions Missing write access to /Users/me/.node-red/node\_modules/my\_proj npm ERR! code ENOENT npm ERR! syscall access np…

---

## [Help for node-red-contrib-redplc-rpi-mcp342x](https://discourse.nodered.org/t/help-for-node-red-contrib-redplc-rpi-mcp342x/52185)

<div class="topic-metadata">

**Author:** [@Max\_Italy](https://discourse.nodered.org/u/Max_Italy)\
**Replies:** 0\
**Last updated:** [13 October 2021 23:26 UTC](https://discourse.nodered.org/t/help-for-node-red-contrib-redplc-rpi-mcp342x/52185 "2021-10-13T23:26:28Z")

</div>

Hello everyone, i am trying to use this node as indicated but i cannot get it to work specifically MCP3424 (4ch). The aim is to use Node Red as a Fixture testing Linux embedded system for electronic boards. Everything…

---

## [Help on how to roll out a new version of a subflow I wrote amongst my machines](https://discourse.nodered.org/t/help-on-how-to-roll-out-a-new-version-of-a-subflow-i-wrote-amongst-my-machines/52113)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 10\
**Last updated:** [13 October 2021 22:36 UTC](https://discourse.nodered.org/t/help-on-how-to-roll-out-a-new-version-of-a-subflow-i-wrote-amongst-my-machines/52113 "2021-10-13T22:36:38Z")

</div>

I've written/made/built a subflow. Maybe not the correct way - not via github - and it has evolved to the next level. I have tried my best to also update the instructions. So how can I get it to all my machines - with…

---

## [Node Red Daemon example](https://discourse.nodered.org/t/node-red-daemon-example/52178)

<div class="topic-metadata">

**Author:** [@chasmccoy](https://discourse.nodered.org/u/chasmccoy)\
**Replies:** 4\
**Last updated:** [13 October 2021 20:39 UTC](https://discourse.nodered.org/t/node-red-daemon-example/52178 "2021-10-13T20:39:43Z")

</div>

Hello all...trying to find an example of a configured node red Daemon. I'm currently using an Exec Node in Node Red 2.06 and it works like a charm, except for I want ability to read stdin while running. So I tried out …

---

## [Help with my images SVG please](https://discourse.nodered.org/t/help-with-my-images-svg-please/52102)

<div class="topic-metadata">

**Author:** [@RicardoCotrina](https://discourse.nodered.org/u/RicardoCotrina)\
**Replies:** 4\
**Last updated:** [13 October 2021 19:16 UTC](https://discourse.nodered.org/t/help-with-my-images-svg-please/52102 "2021-10-13T19:16:43Z")

</div>

I'm using some SVG image templates, and I have 2 that I wish would show up. One on top of the other and vice versa when you click. That is to say, that the images alternate. Thank you, I will be aware of your comments. …

---

## [Clear Date Picker](https://discourse.nodered.org/t/clear-date-picker/52169)

<div class="topic-metadata">

**Author:** [@ecombs](https://discourse.nodered.org/u/ecombs)\
**Replies:** 6\
**Last updated:** [13 October 2021 18:55 UTC](https://discourse.nodered.org/t/clear-date-picker/52169 "2021-10-13T18:55:16Z")

</div>

Using the ui datepicker node I can't figure out how to clear it. I dont want the last date to send if its not needed. send a null msg doesn't work. Any help would be much appreciated.

---

## [PLC to Node-Red](https://discourse.nodered.org/t/plc-to-node-red/52163)

<div class="topic-metadata">

**Author:** [@rolfStudent](https://discourse.nodered.org/u/rolfStudent)\
**Replies:** 2\
**Last updated:** [13 October 2021 16:51 UTC](https://discourse.nodered.org/t/plc-to-node-red/52163 "2021-10-13T16:51:43Z")

</div>

I'm working on a project where the aim is to connect a number of machines with different PLCs to Node-red and send alarm signals via mqtt. The PLCs are Mitsubishi, old and new ones. My experience of PLCs are basically z…

---

## [Grafana getting data / filtering data from node-red?](https://discourse.nodered.org/t/grafana-getting-data-filtering-data-from-node-red/52110)

<div class="topic-metadata">

**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\
**Replies:** 5\
**Last updated:** [13 October 2021 16:34 UTC](https://discourse.nodered.org/t/grafana-getting-data-filtering-data-from-node-red/52110 "2021-10-13T16:34:29Z")

</div>

Playing with Grafana and some open source I found on the internet, I have plenty of data (350k+ entries) and want to display them, while saving them to influx DB was easy, and using the built-in Datasource connector. I f…

---

## [Question about subflows](https://discourse.nodered.org/t/question-about-subflows/52147)

<div class="topic-metadata">

**Author:** [@krambriw](https://discourse.nodered.org/u/krambriw)\
**Replies:** 12\
**Last updated:** [13 October 2021 15:10 UTC](https://discourse.nodered.org/t/question-about-subflows/52147 "2021-10-13T15:10:29Z")

</div>

Hi, I wonder if a running instance of a subflow has some unique id? I need to temporary save a variable in (i.e. in global context) unique to a subsystem instance. If there is, is there then any way to "grab" that id fr…

---

## [Pulling historical data from Twitter API and writing to a CVS file](https://discourse.nodered.org/t/pulling-historical-data-from-twitter-api-and-writing-to-a-cvs-file/52167)

<div class="topic-metadata">

**Author:** [@stanno](https://discourse.nodered.org/u/stanno)\
**Replies:** 0\
**Last updated:** [13 October 2021 14:54 UTC](https://discourse.nodered.org/t/pulling-historical-data-from-twitter-api-and-writing-to-a-cvs-file/52167 "2021-10-13T14:54:27Z")

</div>

Hello all, I've recently started using nodeRed so naturally, I've run into difficulties and really need some help piecing phase 2 of my project together. The Standard Track TwitterAPI allows for access to the past 7 day…

---

## [How can I stop spline-curve from spamming my logs every 2 minutes?](https://discourse.nodered.org/t/how-can-i-stop-spline-curve-from-spamming-my-logs-every-2-minutes/52096)

<div class="topic-metadata">

**Author:** [@DeadBranch](https://discourse.nodered.org/u/DeadBranch)\
**Replies:** 2\
**Last updated:** [13 October 2021 14:35 UTC](https://discourse.nodered.org/t/how-can-i-stop-spline-curve-from-spamming-my-logs-every-2-minutes/52096 "2021-10-13T14:35:53Z")

</div>

Hello. I'm running Node-Red v2.0.6 in a docker version 20.10.8 container on a Raspberry Pi 3 B+ on Raspbian buster 10. The container is launched by a docker-compose (version 1.21.0) file. I'm not exactly sure when, and…

---

## [S7-in scaling and MinConnect reading issue](https://discourse.nodered.org/t/s7-in-scaling-and-minconnect-reading-issue/50708)

<div class="topic-metadata">

**Author:** [@OmidTmr](https://discourse.nodered.org/u/OmidTmr)\
**Replies:** 6\
**Last updated:** [13 October 2021 14:02 UTC](https://discourse.nodered.org/t/s7-in-scaling-and-minconnect-reading-issue/50708 "2021-10-13T14:02:42Z")

</div>

Hi all, I have a Logo PLC and I'm sending temperature data, collected from a sensor, to MindSphere using the MindConnect node. Recently, I have made adjustments on Soft Comfort in order to have the temp. with a one dec…

---

## [Node Red Admin behind firewall](https://discourse.nodered.org/t/node-red-admin-behind-firewall/52143)

<div class="topic-metadata">

**Author:** [@HarryPottar](https://discourse.nodered.org/u/HarryPottar)\
**Replies:** 4\
**Last updated:** [13 October 2021 13:42 UTC](https://discourse.nodered.org/t/node-red-admin-behind-firewall/52143 "2021-10-13T13:42:38Z")

</div>

HI, We have node red running in a kuberntices cluster, we have Nginx running on the font end. We want to send the admin screen behind a VPN. https://host:1880/#flow. Nginx ignore the #flow, how do we route the admi…

---

## [Install node-red-contrib-zwave](https://discourse.nodered.org/t/install-node-red-contrib-zwave/52140)

<div class="topic-metadata">

**Author:** [@NickB](https://discourse.nodered.org/u/NickB)\
**Replies:** 12\
**Last updated:** [13 October 2021 12:33 UTC](https://discourse.nodered.org/t/install-node-red-contrib-zwave/52140 "2021-10-13T12:33:09Z")

</div>

Hi, I used in the past node-red-contrib-zwave, but today I crashed my node red (I have no idea why, but it did, something with a modbus flow that probably caused a loop or so....) Only option was to delete my flows and…

---

## [Access file or directory in a project repo in Node-Red itself](https://discourse.nodered.org/t/access-file-or-directory-in-a-project-repo-in-node-red-itself/52157)

<div class="topic-metadata">

**Author:** [@AP\_Zero](https://discourse.nodered.org/u/AP_Zero)\
**Replies:** 1\
**Last updated:** [13 October 2021 12:01 UTC](https://discourse.nodered.org/t/access-file-or-directory-in-a-project-repo-in-node-red-itself/52157 "2021-10-13T12:01:32Z")

</div>

Is it possible to access files inside a directory on a git repo? Basically, I need to access sound files that was uploaded in the Node-Red project repository and play it using Node-Red

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

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