# Latest

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

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

**Page:** 272

---

## [Fetch data from SQL database and show that in dashboard](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128)

<div class="topic-metadata">

**Author:** [@Subiksha](https://discourse.nodered.org/u/Subiksha)\
**Replies:** 3\
**Last updated:** [24 November 2023 09:44 UTC](https://discourse.nodered.org/t/fetch-data-from-sql-database-and-show-that-in-dashboard/83128 "2023-11-24T09:44:25Z")

</div>

I am all new to this NODE RED and to this world of automation. :slightly\_smiling\_face: I would like to know how to fetch data from SQL database and show that in my frontend created using template node (usinh html). Curr…

---

## [Multi udp in-out](https://discourse.nodered.org/t/multi-udp-in-out/83087)

<div class="topic-metadata">

**Author:** [@userd](https://discourse.nodered.org/u/userd)\
**Replies:** 20\
**Last updated:** [24 November 2023 06:31 UTC](https://discourse.nodered.org/t/multi-udp-in-out/83087 "2023-11-24T06:31:36Z")

</div>

Hi everuone! I have an power supply uses UDP porotocol. I has multi UDP request for the power supply and i need separate answer from the power supply (answer looks like number - 20.00). Will be good if i can transmit int…

---

## [Node-red-mcu-plugin v1.0: Integrating Node-RED MCU Edition into the Node-RED editor](https://discourse.nodered.org/t/node-red-mcu-plugin-v1-0-integrating-node-red-mcu-edition-into-the-node-red-editor/72693)

<div class="topic-metadata">

**Author:** [@ralphwetzel](https://discourse.nodered.org/u/ralphwetzel)\
**Replies:** 210\
**Last updated:** [23 November 2023 21:30 UTC](https://discourse.nodered.org/t/node-red-mcu-plugin-v1-0-integrating-node-red-mcu-edition-into-the-node-red-editor/72693 "2023-11-23T21:30:27Z")

</div>

About six months ago, @phoddie launched the discussion of an inspiring idea: What if ... one could use Node-RED to program microcontrollers (MCU)? His first thoughts kicked off a development of two components that made t…

---

## [Hello! Is it possible to extract data with an htpp request from a database based on id you provide in an insert field and the result to be an table that contains that id. Node-RED v3.0.2, docker](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125)

<div class="topic-metadata">

**Author:** [@JanIwnl](https://discourse.nodered.org/u/JanIwnl)\
**Replies:** 5\
**Last updated:** [23 November 2023 20:39 UTC](https://discourse.nodered.org/t/hello-is-it-possible-to-extract-data-with-an-htpp-request-from-a-database-based-on-id-you-provide-in-an-insert-field-and-the-result-to-be-an-table-that-contains-that-id-node-red-v3-0-2-docker/83125 "2023-11-23T20:39:19Z")

</div>

i want dynamically the flow to search and extract (based on the id i give in the insert field) the table containg that id. This is the format of the table:

---

## [Help saving cookie with alexa-remote2-applestrudel](https://discourse.nodered.org/t/help-saving-cookie-with-alexa-remote2-applestrudel/82904)

<div class="topic-metadata">

**Author:** [@Xenos](https://discourse.nodered.org/u/Xenos)\
**Replies:** 16\
**Last updated:** [23 November 2023 19:29 UTC](https://discourse.nodered.org/t/help-saving-cookie-with-alexa-remote2-applestrudel/82904 "2023-11-23T19:29:39Z")

</div>

I'm using node-red-contrib-alexa-remote2-applestrudel with node-red on windows 11 and for the life of me I cant figure out how to save the cookie. Any tips?

---

## [Node-red-node-pi-gpiod variable as host](https://discourse.nodered.org/t/node-red-node-pi-gpiod-variable-as-host/83107)

<div class="topic-metadata">

**Author:** [@kxkayser](https://discourse.nodered.org/u/kxkayser)\
**Replies:** 7\
**Last updated:** [23 November 2023 18:19 UTC](https://discourse.nodered.org/t/node-red-node-pi-gpiod-variable-as-host/83107 "2023-11-23T18:19:41Z")

</div>

Hi. I have been using node-red-node-pi-gpiod for years to control remote gpio pins. I have always hard coded the IP address of the target host. I want to use a variable (flow context) instead. However, I keep getting …

---

## [Msg.payload for TimerTag.PRE & TimerTag.ACC from Rockwell PLC](https://discourse.nodered.org/t/msg-payload-for-timertag-pre-timertag-acc-from-rockwell-plc/83013)

<div class="topic-metadata">

**Author:** [@bachphi](https://discourse.nodered.org/u/bachphi)\
**Replies:** 3\
**Last updated:** [23 November 2023 17:32 UTC](https://discourse.nodered.org/t/msg-payload-for-timertag-pre-timertag-acc-from-rockwell-plc/83013 "2023-11-23T17:32:58Z")

</div>

These two tags were defined in my eth-ip node and I can see their values in debug. How can I pass these values using msg.payload?

---

## [Node-RED Flows for the StableCode-Completion-Alpha-3B-4K AI model](https://discourse.nodered.org/t/node-red-flows-for-the-stablecode-completion-alpha-3b-4k-ai-model/83124)

<div class="topic-metadata">

**Author:** [@rozek](https://discourse.nodered.org/u/rozek)\
**Replies:** 4\
**Last updated:** [23 November 2023 16:00 UTC](https://discourse.nodered.org/t/node-red-flows-for-the-stablecode-completion-alpha-3b-4k-ai-model/83124 "2023-11-23T16:00:18Z")

</div>

Just to let you know: I've just published a flow with HTTP endpoints for text completion and prompt tokenization Stability AI's StableCode-Completion-Alpha-3B-4K model using ggml under the hood for inferencing on one's…

---

## [Edit node: a keybind for the cancel button](https://discourse.nodered.org/t/edit-node-a-keybind-for-the-cancel-button/83102)

<div class="topic-metadata">

**Author:** [@NorWiz49](https://discourse.nodered.org/u/NorWiz49)\
**Replies:** 3\
**Last updated:** [23 November 2023 14:51 UTC](https://discourse.nodered.org/t/edit-node-a-keybind-for-the-cancel-button/83102 "2023-11-23T14:51:48Z")

</div>

I'd like to suggest we add a key bind for the cancel button on the "edit node" , I think the default button should be the ESCAPE key. After double-clicking on a node in the editor, the "edit xxxx node" pops out from the…

---

## [403 - From POST HTTPS depending on size of body](https://discourse.nodered.org/t/403-from-post-https-depending-on-size-of-body/82716)

<div class="topic-metadata">

**Author:** [@kayna](https://discourse.nodered.org/u/kayna)\
**Replies:** 3\
**Last updated:** [23 November 2023 14:30 UTC](https://discourse.nodered.org/t/403-from-post-https-depending-on-size-of-body/82716 "2023-11-23T14:30:14Z")

</div>

Hi, i'm getting the 403 response for my endpoint in the "http-in" node when the request is made through HTTPS. But it only occurs when in the body of the request there are 3 or more items in the array that i send. If i s…

---

## [Help with dashboard buttons and \`disable\` text to be displayed](https://discourse.nodered.org/t/help-with-dashboard-buttons-and-disable-text-to-be-displayed/83120)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 12\
**Last updated:** [23 November 2023 11:10 UTC](https://discourse.nodered.org/t/help-with-dashboard-buttons-and-disable-text-to-be-displayed/83120 "2023-11-23T11:10:09Z")

</div>

Folks, I have entered a seldom visited area. I have buttons on the dashboard and sometimes they need to be disabled. Sending a message with msg.enable set to false disables the buttons for input/being pressed. All wel…

---

## [Node-red-plc-next-connector : no access to the variables](https://discourse.nodered.org/t/node-red-plc-next-connector-no-access-to-the-variables/83126)

<div class="topic-metadata">

**Author:** [@mike67](https://discourse.nodered.org/u/mike67)\
**Replies:** 0\
**Last updated:** [23 November 2023 10:40 UTC](https://discourse.nodered.org/t/node-red-plc-next-connector-no-access-to-the-variables/83126 "2023-11-23T10:40:28Z")

</div>

Hello I use NodeRed 3.0.2 on a device from PhoenixContact (based of Debian) AXC F 2152. I use the node-red-plc-next-connector which permits to access to the variables of this device. The node Read Variables presents t…

---

## [The catalogue hasn't been updated since four days](https://discourse.nodered.org/t/the-catalogue-hasnt-been-updated-since-four-days/83119)

<div class="topic-metadata">

**Author:** [@RvG](https://discourse.nodered.org/u/RvG)\
**Replies:** 6\
**Last updated:** [23 November 2023 08:30 UTC](https://discourse.nodered.org/t/the-catalogue-hasnt-been-updated-since-four-days/83119 "2023-11-23T08:30:00Z")

</div>

The nodes catalogue hasn't been updated in the last few days. The last update was on Sunday, November 19: "updated\_at": "2023-11-19T10:16:32.928Z" And yes, there have been new node releases since then. Maybe some proce…

---

## [UIBUILDER 6.5 question about updateing html parts and classes](https://discourse.nodered.org/t/uibuilder-6-5-question-about-updateing-html-parts-and-classes/83112)

<div class="topic-metadata">

**Author:** [@daspixel](https://discourse.nodered.org/u/daspixel)\
**Replies:** 1\
**Last updated:** [23 November 2023 00:49 UTC](https://discourse.nodered.org/t/uibuilder-6-5-question-about-updateing-html-parts-and-classes/83112 "2023-11-23T00:49:33Z")

</div>

Hi, this question are about 6.5 I allready updated to 6.6 but not to 6.7 (but I will do as soon as possible) Actually I do have static coded html "elements" that are looking like this \<div class="i…

---

## [\[ANNOUNCE\] node-red-contrib-blockly version 2.4.0](https://discourse.nodered.org/t/announce-node-red-contrib-blockly-version-2-4-0/83114)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 2\
**Last updated:** [22 November 2023 23:47 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-blockly-version-2-4-0/83114 "2023-11-22T23:47:27Z")

</div>

Hi folks, Version 2.4.0 of the node-red-contrib-blockly is available in the palette :partying\_face: :champagne: :clinking\_glasses: This version contains the following changes: New block to convert a buffer to a list…

---

## [New Shelly wall display (and alternatives?)](https://discourse.nodered.org/t/new-shelly-wall-display-and-alternatives/80961)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 52\
**Last updated:** [22 November 2023 21:04 UTC](https://discourse.nodered.org/t/new-shelly-wall-display-and-alternatives/80961 "2023-11-22T21:04:54Z")

</div>

Hi folks, Long time ago we had a discussion in this community about small wall mount touch screens with embedded temperature and humidity sensor. Today in the live stream from Shelly they presented some new devices, in…

---

## [GS-T3E display with OpenHASP](https://discourse.nodered.org/t/gs-t3e-display-with-openhasp/83111)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 0\
**Last updated:** [22 November 2023 20:59 UTC](https://discourse.nodered.org/t/gs-t3e-display-with-openhasp/83111 "2023-11-22T20:59:35Z")

</div>

next post from my homepage in german under GS-T3E Display mit OpenHASP – Smarthome von Stefan B. After various forum posts regarding new touch displays with 480×480 pixels and switch function that also work with OpenHAS…

---

## [Implment data base](https://discourse.nodered.org/t/implment-data-base/83095)

<div class="topic-metadata">

**Author:** [@modmeid](https://discourse.nodered.org/u/modmeid)\
**Replies:** 4\
**Last updated:** [22 November 2023 20:46 UTC](https://discourse.nodered.org/t/implment-data-base/83095 "2023-11-22T20:46:22Z")

</div>

Hi Guys , I'm new in node red , I have to implement these data into node red can you please guide me how to do that ? , this is wha node red shows me t

---

## [Ulanzi Display TC001 with Awtrix-Light](https://discourse.nodered.org/t/ulanzi-display-tc001-with-awtrix-light/83108)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 0\
**Last updated:** [22 November 2023 19:19 UTC](https://discourse.nodered.org/t/ulanzi-display-tc001-with-awtrix-light/83108 "2023-11-22T19:19:27Z")

</div>

I wrote a german review on my homepage about the Ulanzi Display TC001, which can be flashed with Awtrix-Light and then controlled by MQTT: https://smarthome.sb242.de/hardware/ulanzi-display-tc001-mit-awtrix-light/ I wi…

---

## [Putting the value of a global variable inside a line of an object from inject](https://discourse.nodered.org/t/putting-the-value-of-a-global-variable-inside-a-line-of-an-object-from-inject/83104)

<div class="topic-metadata">

**Author:** [@Sysmac](https://discourse.nodered.org/u/Sysmac)\
**Replies:** 2\
**Last updated:** [22 November 2023 18:33 UTC](https://discourse.nodered.org/t/putting-the-value-of-a-global-variable-inside-a-line-of-an-object-from-inject/83104 "2023-11-22T18:33:02Z")

</div>

Inject node has { "metrics": \[ { "name": "testing/test1", "value": 11 }, { "name": "testing/test2", "value": 12 } \] } I then use the JSON node to convert to a string "{"metrics":\[{"name":"testing/test1","va…

---

## [GIT project clone "Authentication failed"](https://discourse.nodered.org/t/git-project-clone-authentication-failed/82953)

<div class="topic-metadata">

**Author:** [@alexgorbatchev](https://discourse.nodered.org/u/alexgorbatchev)\
**Replies:** 3\
**Last updated:** [22 November 2023 17:43 UTC](https://discourse.nodered.org/t/git-project-clone-authentication-failed/82953 "2023-11-22T17:43:42Z")

</div>

Hi friends, I've been trying to figure this out for days. Problem: I have a node-red v3.1.0 and gitea v1.21.0 running in a Kubernetes cluster. I'm adding public/private keys to node-red via a secret and gitea user ha…

---

## [FR: Give context to RED.validators.typedInput](https://discourse.nodered.org/t/fr-give-context-to-red-validators-typedinput/82943)

<div class="topic-metadata">

**Author:** [@GogoVega](https://discourse.nodered.org/u/GogoVega)\
**Replies:** 1\
**Last updated:** [22 November 2023 17:20 UTC](https://discourse.nodered.org/t/fr-give-context-to-red-validators-typedinput/82943 "2023-11-22T17:20:47Z")

</div>

Hi team, Would it be possible to give a context to RED.validators.typedInput? I would like to validate inputs in a container with typedInput validator but for now it's not possible because the global context is used an…

---

## [What does the error code "port not open" mean?](https://discourse.nodered.org/t/what-does-the-error-code-port-not-open-mean/83101)

<div class="topic-metadata">

**Author:** [@Maans](https://discourse.nodered.org/u/Maans)\
**Replies:** 0\
**Last updated:** [22 November 2023 14:59 UTC](https://discourse.nodered.org/t/what-does-the-error-code-port-not-open-mean/83101 "2023-11-22T14:59:46Z")

</div>

Im trying to use a siemens iot2050 to read values from PAC3220. But from my modbus read node I get the error "Port not open". How do I fix this?

---

## [Select Dropdown with Hierarchy](https://discourse.nodered.org/t/select-dropdown-with-hierarchy/83096)

<div class="topic-metadata">

**Author:** [@germancmartinez](https://discourse.nodered.org/u/germancmartinez)\
**Replies:** 2\
**Last updated:** [22 November 2023 14:50 UTC](https://discourse.nodered.org/t/select-dropdown-with-hierarchy/83096 "2023-11-22T14:50:32Z")

</div>

Hi! Is there a way to implement a Select Dropdown with Hierarchy in the Editor?

---

## [Node.name acces in dashboard V1 template node](https://discourse.nodered.org/t/node-name-acces-in-dashboard-v1-template-node/83088)

<div class="topic-metadata">

**Author:** [@jtalbourdet](https://discourse.nodered.org/u/jtalbourdet)\
**Replies:** 2\
**Last updated:** [22 November 2023 12:31 UTC](https://discourse.nodered.org/t/node-name-acces-in-dashboard-v1-template-node/83088 "2023-11-22T12:31:45Z")

</div>

Hello Node-Red community, Can anyone tell me if it's possible to access the variable node.name in a template node as we would do in a function node? Thanks in advance.

---

## [Mocking a dependent library in a UnitTest](https://discourse.nodered.org/t/mocking-a-dependent-library-in-a-unittest/82728)

<div class="topic-metadata">

**Author:** [@Stwissel](https://discourse.nodered.org/u/Stwissel)\
**Replies:** 3\
**Last updated:** [22 November 2023 12:05 UTC](https://discourse.nodered.org/t/mocking-a-dependent-library-in-a-unittest/82728 "2023-11-22T12:05:50Z")

</div>

I'm developing a node that uses a library to call out to an external system. To unit test I need to mock it. What do I do? My node is roughly like this: const backend = require('./theDarkSide\`); module.exports = functio…

---

## [Démo via short Video allowed or not](https://discourse.nodered.org/t/demo-via-short-video-allowed-or-not/83076)

<div class="topic-metadata">

**Author:** [@Jean-Luc](https://discourse.nodered.org/u/Jean-Luc)\
**Replies:** 9\
**Last updated:** [22 November 2023 10:52 UTC](https://discourse.nodered.org/t/demo-via-short-video-allowed-or-not/83076 "2023-11-22T10:52:45Z")

</div>

in the "share your projects" category, is it allowed to show a short video (1-2 min) of what was accomplished with NR? It's not commercial software, just the result of my work that I'm giving to the winds. (I don't wa…

---

## [I want to use modbus-write to receive string data](https://discourse.nodered.org/t/i-want-to-use-modbus-write-to-receive-string-data/83071)

<div class="topic-metadata">

**Author:** [@suwan.a](https://discourse.nodered.org/u/suwan.a)\
**Replies:** 2\
**Last updated:** [22 November 2023 09:53 UTC](https://discourse.nodered.org/t/i-want-to-use-modbus-write-to-receive-string-data/83071 "2023-11-22T09:53:39Z")

</div>

I want to use modbus-write to get data from a previous function. Numeric data can be displayed. But the string data cannot be displayed. What should I do next?

---

## [Create Customized Production Report using Omron FINS](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077)

<div class="topic-metadata">

**Author:** [@jagades](https://discourse.nodered.org/u/jagades)\
**Replies:** 4\
**Last updated:** [22 November 2023 09:10 UTC](https://discourse.nodered.org/t/create-customized-production-report-using-omron-fins/83077 "2023-11-22T09:10:04Z")

</div>

Hello, I am searching for ways to create customized reports from Omron PLC. Basically my plan is to use Omron FINS protocol, and I have done work related to creating reports on csv formatted file using Omron RS485, throu…

---

## [Data transfer between different flow](https://discourse.nodered.org/t/data-transfer-between-different-flow/83074)

<div class="topic-metadata">

**Author:** [@xpxiong](https://discourse.nodered.org/u/xpxiong)\
**Replies:** 1\
**Last updated:** [22 November 2023 08:15 UTC](https://discourse.nodered.org/t/data-transfer-between-different-flow/83074 "2023-11-22T08:15:00Z")

</div>

I'm trying to bring together data from multiple processes in Node-Red into one process. So you need a way to transfer data between the different flows of Node-Red.

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

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