# Latest

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

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

**Page:** 232

---

## [Node red if function for data selection](https://discourse.nodered.org/t/node-red-if-function-for-data-selection/85688)

<div class="topic-metadata">

**Author:** [@mitchysho](https://discourse.nodered.org/u/mitchysho)\
**Replies:** 4\
**Last updated:** [20 February 2024 12:45 UTC](https://discourse.nodered.org/t/node-red-if-function-for-data-selection/85688 "2024-02-20T12:45:05Z")

</div>

Hi, This is my complete message from my gateway 2/20/2024, 10:29:13 AMnode: allkbeacon/publish/282C0221FD0B : msg.payload : Object object msg: "advData" loc: object gmac: "282C0221FD0B" obj: array\[4\] 0: object 1…

---

## [Inserting Data into SQL database using OPCUA subscription mode](https://discourse.nodered.org/t/inserting-data-into-sql-database-using-opcua-subscription-mode/85691)

<div class="topic-metadata">

**Author:** [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Replies:** 0\
**Last updated:** [20 February 2024 08:32 UTC](https://discourse.nodered.org/t/inserting-data-into-sql-database-using-opcua-subscription-mode/85691 "2024-02-20T08:32:31Z")

</div>

Hi Guys! With OPCUA read node and MySQL node, i can inject the PLC value into SQL database. And table looks as below. What i like to know that with OPCUA subscribe node, is it possible to feed data into SQL database …

---

## [Exec node fails with error:127 ... any ideas why?](https://discourse.nodered.org/t/exec-node-fails-with-error-127-any-ideas-why/85675)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 6\
**Last updated:** [19 February 2024 18:21 UTC](https://discourse.nodered.org/t/exec-node-fails-with-error-127-any-ideas-why/85675 "2024-02-19T18:21:34Z")

</div>

Hi, I am running Node-RED in Docker. I am sending text to the Exec node to enable speech output. Text is "Speaker\_in\_PC\_Room" and the command is espeak -s 130 -k3 But I get the errors on the image below. Is it that …

---

## [How do you increase the payload array length in the debug console?](https://discourse.nodered.org/t/how-do-you-increase-the-payload-array-length-in-the-debug-console/85674)

<div class="topic-metadata">

**Author:** [@malee](https://discourse.nodered.org/u/malee)\
**Replies:** 3\
**Last updated:** [19 February 2024 17:30 UTC](https://discourse.nodered.org/t/how-do-you-increase-the-payload-array-length-in-the-debug-console/85674 "2024-02-19T17:30:37Z")

</div>

I am noticing that the array length in the debug console is 999 items. Apparently this can be increased by changing the settings, how do you do this. Also is it possible to increase the string length of each array item s…

---

## [Array - last value](https://discourse.nodered.org/t/array-last-value/85653)

<div class="topic-metadata">

**Author:** [@Moach2000](https://discourse.nodered.org/u/Moach2000)\
**Replies:** 3\
**Last updated:** [19 February 2024 16:29 UTC](https://discourse.nodered.org/t/array-last-value/85653 "2024-02-19T16:29:23Z")

</div>

Hi! I get some data via API (battery status) into my Node-Red. The data has an array - up to 99 arrays and each of this array contains 4 values \[0\]...\[3\]. I want to get the value from the latest array \[80\] out of 80 or…

---

## [Node icons not showing after version 3.1.3](https://discourse.nodered.org/t/node-icons-not-showing-after-version-3-1-3/85655)

<div class="topic-metadata">

**Author:** [@crxporter](https://discourse.nodered.org/u/crxporter)\
**Replies:** 6\
**Last updated:** [19 February 2024 16:09 UTC](https://discourse.nodered.org/t/node-icons-not-showing-after-version-3-1-3/85655 "2024-02-19T16:09:36Z")

</div>

I've just updated to version 3.1.5 and noticed that various node icons are no longer appearing in the editor. For example the Aedes MQTT broker node is now not showing any icon in the editor view - but it does show the i…

---

## [Node-red-contrib-spark](https://discourse.nodered.org/t/node-red-contrib-spark/85555)

<div class="topic-metadata">

**Author:** [@RafaBravo](https://discourse.nodered.org/u/RafaBravo)\
**Replies:** 4\
**Last updated:** [19 February 2024 11:00 UTC](https://discourse.nodered.org/t/node-red-contrib-spark/85555 "2024-02-19T11:00:38Z")

</div>

I try to work with node-red-contrib-spark not communicate with cisco webex team. but I get a 400 request error. I get a temporary beare token from the web https://developer.webex.com/docs/api/v1/messages/create-a-message …

---

## [DB2 - Flat style of v-card](https://discourse.nodered.org/t/db2-flat-style-of-v-card/85629)

<div class="topic-metadata">

**Author:** [@Waz](https://discourse.nodered.org/u/Waz)\
**Replies:** 5\
**Last updated:** [19 February 2024 06:48 UTC](https://discourse.nodered.org/t/db2-flat-style-of-v-card/85629 "2024-02-19T06:48:18Z")

</div>

This should be a simple one. Sorry for noob front-end questions - I guess this happens with the change of architecture. I can't seem to get the flat (borderless look) on a v-card. It works in Vuetify Playground etc. \<t…

---

## [Set different colors to the tab](https://discourse.nodered.org/t/set-different-colors-to-the-tab/85662)

<div class="topic-metadata">

**Author:** [@vinodsr](https://discourse.nodered.org/u/vinodsr)\
**Replies:** 0\
**Last updated:** [19 February 2024 07:02 UTC](https://discourse.nodered.org/t/set-different-colors-to-the-tab/85662 "2024-02-19T07:02:43Z")

</div>

I would like to have a option in the tab menu, where i can set a color for the tab from a list of colors. This helps to categorize the huge number of tabs.

---

## [Creating a if statement inside an if statement in a Javascript function node](https://discourse.nodered.org/t/creating-a-if-statement-inside-an-if-statement-in-a-javascript-function-node/68663)

<div class="topic-metadata">

**Author:** [@Breathly](https://discourse.nodered.org/u/Breathly)\
**Replies:** 6\
**Last updated:** [19 February 2024 06:42 UTC](https://discourse.nodered.org/t/creating-a-if-statement-inside-an-if-statement-in-a-javascript-function-node/68663 "2024-02-19T06:42:14Z")

</div>

Hey guys, currently i have some problems with not knowing how to create a if satement inside a if statement in a Javascript function node, currently last piece i need to do for my project to work. How do i do this? Is it…

---

## [Johnny five does not display analog signals of Beaglebone black](https://discourse.nodered.org/t/johnny-five-does-not-display-analog-signals-of-beaglebone-black/85529)

<div class="topic-metadata">

**Author:** [@Pitufo](https://discourse.nodered.org/u/Pitufo)\
**Replies:** 2\
**Last updated:** [19 February 2024 00:06 UTC](https://discourse.nodered.org/t/johnny-five-does-not-display-analog-signals-of-beaglebone-black/85529 "2024-02-19T00:06:13Z")

</div>

Hello again I had installed the johnny five node on my node-red , but I noticed that it only gives me access to the digital inputs and outputs and not to the analog inputs , which are the ones I am most interested in. U…

---

## [Fatal error node red](https://discourse.nodered.org/t/fatal-error-node-red/85651)

<div class="topic-metadata">

**Author:** [@telescopio](https://discourse.nodered.org/u/telescopio)\
**Replies:** 1\
**Last updated:** [18 February 2024 20:18 UTC](https://discourse.nodered.org/t/fatal-error-node-red/85651 "2024-02-18T20:18:09Z")

</div>

Node red stop running and show this error when I was connecting to a database. 18 Feb 15:56:44 - \[red\] Uncaught Exception: 18 Feb 15:56:44 - \[error\] error: database "obs" does not exist at C:\\Users\\Casa.node-red\\node\_…

---

## [SubFlow with UI\_node and group inside](https://discourse.nodered.org/t/subflow-with-ui-node-and-group-inside/85642)

<div class="topic-metadata">

**Author:** [@corso66](https://discourse.nodered.org/u/corso66)\
**Replies:** 5\
**Last updated:** [18 February 2024 16:38 UTC](https://discourse.nodered.org/t/subflow-with-ui-node-and-group-inside/85642 "2024-02-18T16:38:10Z")

</div>

Hello everybody ! I'm working a new node-red project with Zigbee protocol network. Now that all communications system between node-red and zigbees runs properly, i would want to have possibility to create easily and re…

---

## [Node-Red to InfluxDB](https://discourse.nodered.org/t/node-red-to-influxdb/85639)

<div class="topic-metadata">

**Author:** [@jonas123](https://discourse.nodered.org/u/jonas123)\
**Replies:** 3\
**Last updated:** [18 February 2024 15:39 UTC](https://discourse.nodered.org/t/node-red-to-influxdb/85639 "2024-02-18T15:39:30Z")

</div>

Hello all, I'm relatively new in programming and microcontrollers. I hope to find her some help for my project. I want to read out a BME280 sensor (Temperature, humidity, pressure) with an ESP32. The ESP32 is serial con…

---

## [Dashboard 2.0 Object.hasOwn is not a function](https://discourse.nodered.org/t/dashboard-2-0-object-hasown-is-not-a-function/85603)

<div class="topic-metadata">

**Author:** [@nodouser](https://discourse.nodered.org/u/nodouser)\
**Replies:** 18\
**Last updated:** [18 February 2024 15:37 UTC](https://discourse.nodered.org/t/dashboard-2-0-object-hasown-is-not-a-function/85603 "2024-02-18T15:37:05Z")

</div>

Hi, I just started with dashboard 2.0 , it works, but there is an error. What is the reason of this error? I'm trying to understand what causes this

---

## [Command line to show all versions running](https://discourse.nodered.org/t/command-line-to-show-all-versions-running/85637)

<div class="topic-metadata">

**Author:** [@GiovanniG](https://discourse.nodered.org/u/GiovanniG)\
**Replies:** 1\
**Last updated:** [18 February 2024 13:58 UTC](https://discourse.nodered.org/t/command-line-to-show-all-versions-running/85637 "2024-02-18T13:58:35Z")

</div>

Hi, I kindly ask you to introduce a brief command to check quikly all versions of important system's components running, Steve-Mcl suggested kindly a very effective one echo -e "Kernel:\\t\\t$(uname -r)\\nNode.js:\\t$(node…

---

## [Rpi-gpio out node not performing](https://discourse.nodered.org/t/rpi-gpio-out-node-not-performing/85617)

<div class="topic-metadata">

**Author:** [@luemar](https://discourse.nodered.org/u/luemar)\
**Replies:** 20\
**Last updated:** [18 February 2024 13:48 UTC](https://discourse.nodered.org/t/rpi-gpio-out-node-not-performing/85617 "2024-02-18T13:48:26Z")

</div>

For controlling an LED with Node-RED I set up my flow according to the instructions in section 2.5. However, the box blow the rpi-gpio out node indicates "not available". If I klick the injection nodes nothing happens. …

---

## [A command line to show all versions running](https://discourse.nodered.org/t/a-command-line-to-show-all-versions-running/85636)

<div class="topic-metadata">

**Author:** [@GiovanniG](https://discourse.nodered.org/u/GiovanniG)\
**Replies:** 5\
**Last updated:** [18 February 2024 10:32 UTC](https://discourse.nodered.org/t/a-command-line-to-show-all-versions-running/85636 "2024-02-18T10:32:01Z")

</div>

Hi mates, may I please suggest to create a command line, for example node-red-version where is possible to show all important informations at the same time, thank you! uname -r node -v npm -v node-red --h

---

## [Achieve a more stable flow](https://discourse.nodered.org/t/achieve-a-more-stable-flow/85624)

<div class="topic-metadata">

**Author:** [@theralle](https://discourse.nodered.org/u/theralle)\
**Replies:** 14\
**Last updated:** [18 February 2024 10:26 UTC](https://discourse.nodered.org/t/achieve-a-more-stable-flow/85624 "2024-02-18T10:26:44Z")

</div>

\[info\] Node-RED version: v3.1.5 \[info\] Node.js version: v16.20.2 I have a flow in Node-RED that utilizes the exec node to execute a command. The command is "node /opt/node-red/script/googlehtml.js". The flow tends to …

---

## ['rbe' already registered by module node-red](https://discourse.nodered.org/t/rbe-already-registered-by-module-node-red/84847)

<div class="topic-metadata">

**Author:** [@GiovanniG](https://discourse.nodered.org/u/GiovanniG)\
**Replies:** 6\
**Last updated:** [18 February 2024 10:15 UTC](https://discourse.nodered.org/t/rbe-already-registered-by-module-node-red/84847 "2024-02-18T10:15:04Z")

</div>

Hi, on startup I have this warn, how can I remove it? Thanks \[warn\] \[node-red-node-rbe/rbe\] 'rbe' already registered by module node-red

---

## [First third-party widget published for Dashboard 2.0 (ui-webcam)](https://discourse.nodered.org/t/first-third-party-widget-published-for-dashboard-2-0-ui-webcam/85611)

<div class="topic-metadata">

**Author:** [@joepavitt](https://discourse.nodered.org/u/joepavitt)\
**Replies:** 3\
**Last updated:** [18 February 2024 09:26 UTC](https://discourse.nodered.org/t/first-third-party-widget-published-for-dashboard-2-0-ui-webcam/85611 "2024-02-18T09:26:26Z")

</div>

I just wanted to do a shout out and public "Thank You" to @sumitshinde-84 who is officially the publisher and developer of the first third-party widget for Dashboard 2.0 - ui-webcam! It's available now in the Node-RED C…

---

## [End time before start time](https://discourse.nodered.org/t/end-time-before-start-time/85634)

<div class="topic-metadata">

**Author:** [@JJussi](https://discourse.nodered.org/u/JJussi)\
**Replies:** 1\
**Last updated:** [18 February 2024 07:41 UTC](https://discourse.nodered.org/t/end-time-before-start-time/85634 "2024-02-18T07:41:19Z")

</div>

Hi! I noticed that NodeRed (at Home Assistant) cannot handle situations where the end time (sunrise) is before the start time (08:00). I have this action, that turns the light on at 08:00 in the morning (at the weekend…

---

## [Can't change the right margin](https://discourse.nodered.org/t/cant-change-the-right-margin/85605)

<div class="topic-metadata">

**Author:** [@Waz](https://discourse.nodered.org/u/Waz)\
**Replies:** 2\
**Last updated:** [17 February 2024 10:36 UTC](https://discourse.nodered.org/t/cant-change-the-right-margin/85605 "2024-02-17T10:36:52Z")

</div>

Hi, I've tried setting the UI-Theme and direct class in the v-card with class="ma-3" and individually with "mr-3". I can't seem to inset the right margin. The ui-template is page scoped because I also can't adjust the p…

---

## [Insert data from udp](https://discourse.nodered.org/t/insert-data-from-udp/85627)

<div class="topic-metadata">

**Author:** [@telescopio](https://discourse.nodered.org/u/telescopio)\
**Replies:** 4\
**Last updated:** [18 February 2024 00:51 UTC](https://discourse.nodered.org/t/insert-data-from-udp/85627 "2024-02-18T00:51:13Z")

</div>

HI I have this data coming from a MQTT connect to my weather station: dataGMTTime=2023/07/05 03:38:46 cwinfo=Serial: 2387, FW: 5.88 clouds=34.350000 temp=34.310000 wind=-1 gust=-1 rain=2450 lightmpsas=23.57 switch=0 sa…

---

## [Sequence automation](https://discourse.nodered.org/t/sequence-automation/85626)

<div class="topic-metadata">

**Author:** [@FAH2022](https://discourse.nodered.org/u/FAH2022)\
**Replies:** 1\
**Last updated:** [17 February 2024 21:54 UTC](https://discourse.nodered.org/t/sequence-automation/85626 "2024-02-17T21:54:47Z")

</div>

Hi all, I am pretty new and still exploring NR automation approaches. Hope I am right here raising some noob questions? I want to realize the following light automation: If night (simple KNX Status) and light 2 is on …

---

## [Tiggering xstate machine](https://discourse.nodered.org/t/tiggering-xstate-machine/85620)

<div class="topic-metadata">

**Author:** [@Hogi](https://discourse.nodered.org/u/Hogi)\
**Replies:** 6\
**Last updated:** [17 February 2024 21:34 UTC](https://discourse.nodered.org/t/tiggering-xstate-machine/85620 "2024-02-17T21:34:42Z")

</div>

Hi all I am new here (from Germany) and also new in using Node Red. I am looking for some support on xstate machine. I have implemented the states but I am failing triggering the transitions from outside. My transitio…

---

## [How to change text color in node-red-node-ui-table](https://discourse.nodered.org/t/how-to-change-text-color-in-node-red-node-ui-table/85517)

<div class="topic-metadata">

**Author:** [@RandyBryant](https://discourse.nodered.org/u/RandyBryant)\
**Replies:** 7\
**Last updated:** [17 February 2024 19:16 UTC](https://discourse.nodered.org/t/how-to-change-text-color-in-node-red-node-ui-table/85517 "2024-02-17T19:16:17Z")

</div>

I can change the background color using: message.ui\_control = { tabulator: { rowFormatter: (function (row) { row.getElement().style.backgroundColor = 'red'; //row.getElement().style.c…

---

## [Slow deployment on a different machine](https://discourse.nodered.org/t/slow-deployment-on-a-different-machine/85595)

<div class="topic-metadata">

**Author:** [@nygma2004](https://discourse.nodered.org/u/nygma2004)\
**Replies:** 8\
**Last updated:** [17 February 2024 15:58 UTC](https://discourse.nodered.org/t/slow-deployment-on-a-different-machine/85595 "2024-02-17T15:58:11Z")

</div>

Today, I am working from home and on my company laptop. I have a bit of downtime and decided to do some work in NR. I still access it locally, with the same local IP (http://192.168.1.80/) as on my home computer. Deployi…

---

## [Editor Browser Tab Title](https://discourse.nodered.org/t/editor-browser-tab-title/85604)

<div class="topic-metadata">

**Author:** [@dunum](https://discourse.nodered.org/u/dunum)\
**Replies:** 3\
**Last updated:** [17 February 2024 15:39 UTC](https://discourse.nodered.org/t/editor-browser-tab-title/85604 "2024-02-17T15:39:01Z")

</div>

Hi The change to the editor browser title introduced into Node-RED version 3.1.5 (discussed here Editor Browser Tab Title?) causes me problems when multiple browser tabs are open, each editing flows on different machin…

---

## [Node-RED freezes while sqlite query](https://discourse.nodered.org/t/node-red-freezes-while-sqlite-query/84675)

<div class="topic-metadata">

**Author:** [@mima232](https://discourse.nodered.org/u/mima232)\
**Replies:** 23\
**Last updated:** [17 February 2024 14:51 UTC](https://discourse.nodered.org/t/node-red-freezes-while-sqlite-query/84675 "2024-02-17T14:51:10Z")

</div>

Hello, Im using the latest node-red-node-sqlite for querying my database. Unfortunately just realised, that the query totally blocks whole Node-RED ... which in some cases can take tens of seconds, even minutes. As the …

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

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