# Latest

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

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

**Page:** 608

---

## [Node-red in docker container - apt command not found](https://discourse.nodered.org/t/node-red-in-docker-container-apt-command-not-found/59895)

<div class="topic-metadata">

**Author:** [@lab](https://discourse.nodered.org/u/lab)\
**Replies:** 1\
**Last updated:** [15 March 2022 17:30 UTC](https://discourse.nodered.org/t/node-red-in-docker-container-apt-command-not-found/59895 "2022-03-15T17:30:30Z")

</div>

I have node-red installed on my docker server running on ubuntu 21.10: docker run -it -p 1880:1880 -v node\_red\_data:/data --name mynodered nodered/node-red And wanted to install the imagemagick software in the same con…

---

## [Utf8 decoding from serial buffer](https://discourse.nodered.org/t/utf8-decoding-from-serial-buffer/59884)

<div class="topic-metadata">

**Author:** [@leifnel](https://discourse.nodered.org/u/leifnel)\
**Replies:** 4\
**Last updated:** [15 March 2022 16:24 UTC](https://discourse.nodered.org/t/utf8-decoding-from-serial-buffer/59884 "2022-03-15T16:24:09Z")

</div>

I'm getting data from a serial port., including danish characters æøå = c6 f8 c5 I need to convert this to c3 a6 c3 b8 c3 a5 If i send the data through the iconv node, set the encoding to utf8, I just get \<?\> character…

---

## [Help cumulative values](https://discourse.nodered.org/t/help-cumulative-values/59882)

<div class="topic-metadata">

**Author:** [@CelioRodrigues](https://discourse.nodered.org/u/CelioRodrigues)\
**Replies:** 5\
**Last updated:** [15 March 2022 14:22 UTC](https://discourse.nodered.org/t/help-cumulative-values/59882 "2022-03-15T14:22:18Z")

</div>

I'm kind of new to node-red and JS. I've been trying to create a cumulative function to help with industrial monitoring. We have some variables that we bring with PLC node, we want know how many % per day the machine pa…

---

## [Using projects as a back up?](https://discourse.nodered.org/t/using-projects-as-a-back-up/59844)

<div class="topic-metadata">

**Author:** [@magicman](https://discourse.nodered.org/u/magicman)\
**Replies:** 8\
**Last updated:** [15 March 2022 14:19 UTC](https://discourse.nodered.org/t/using-projects-as-a-back-up/59844 "2022-03-15T14:19:43Z")

</div>

May i ask if i transfer my flows to a project then commit the project from my linux server can i then pull back the flows onto my windows PC and run node-red with these flows or is it more complicated that that? and if i…

---

## [Using Subflows within Node-RED unit tests (node-red-node-test-helper) does NOT work](https://discourse.nodered.org/t/using-subflows-within-node-red-unit-tests-node-red-node-test-helper-does-not-work/59081)

<div class="topic-metadata">

**Author:** [@BeginnerNode](https://discourse.nodered.org/u/BeginnerNode)\
**Replies:** 6\
**Last updated:** [15 March 2022 14:19 UTC](https://discourse.nodered.org/t/using-subflows-within-node-red-unit-tests-node-red-node-test-helper-does-not-work/59081 "2022-03-15T14:19:42Z")

</div>

Hello together, I have created several unit tests using node-red-node-test-helper to have end-to-end tests of my flow containg 4 nodes: A input B function C function D output Test worked without any problems for th…

---

## [Projects - diff - is there a way to limit to filter to only what changed?](https://discourse.nodered.org/t/projects-diff-is-there-a-way-to-limit-to-filter-to-only-what-changed/59859)

<div class="topic-metadata">

**Author:** [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Replies:** 6\
**Last updated:** [15 March 2022 14:17 UTC](https://discourse.nodered.org/t/projects-diff-is-there-a-way-to-limit-to-filter-to-only-what-changed/59859 "2022-03-15T14:17:32Z")

</div>

Hi , I started using the Projects feature of NR recently. And i am amazed at it. Thank You for this splendid feature. In past i had asked for versioning and diff to be added to v3 - but now i can see Projects already …

---

## [Struggling receiving MQTT messages in Node Red](https://discourse.nodered.org/t/struggling-receiving-mqtt-messages-in-node-red/59878)

<div class="topic-metadata">

**Author:** [@pabutterworth](https://discourse.nodered.org/u/pabutterworth)\
**Replies:** 4\
**Last updated:** [15 March 2022 14:01 UTC](https://discourse.nodered.org/t/struggling-receiving-mqtt-messages-in-node-red/59878 "2022-03-15T14:01:02Z")

</div>

Hi, I'm developing a garage door controller in Node-red running on a piZero under Dietpi that I want to connect to my Home Assistant instance using MQTT. I have the Mosquitto broker installed on the Home Assistance inst…

---

## [Run Node-red on Windows10](https://discourse.nodered.org/t/run-node-red-on-windows10/59816)

<div class="topic-metadata">

**Author:** [@fredshortlv129bis](https://discourse.nodered.org/u/fredshortlv129bis)\
**Replies:** 8\
**Last updated:** [15 March 2022 11:47 UTC](https://discourse.nodered.org/t/run-node-red-on-windows10/59816 "2022-03-15T11:47:53Z")

</div>

After a while of inactivity, I try to connect to Node-Red again, but I cannot access Node-Red and my previous flows. I accidentally deleted my desktop shortcuts. http://127.0.0.1:1880 does not help. I cannot find my p…

---

## [Message Payload Limitations](https://discourse.nodered.org/t/message-payload-limitations/59711)

<div class="topic-metadata">

**Author:** [@StevenMurray2022](https://discourse.nodered.org/u/StevenMurray2022)\
**Replies:** 23\
**Last updated:** [15 March 2022 11:43 UTC](https://discourse.nodered.org/t/message-payload-limitations/59711 "2022-03-15T11:43:09Z")

</div>

I'm trying to pass a message from a mobile using 'SMS Receiver'--\>--'String'--\>--'Serial Output' nodes, but Node red seems to truncate the message after 153 Characters.. The below message is what I'm trying to pass, but…

---

## [How to change the default marker icon in the node-red worldmap node from a function node?](https://discourse.nodered.org/t/how-to-change-the-default-marker-icon-in-the-node-red-worldmap-node-from-a-function-node/59812)

<div class="topic-metadata">

**Author:** [@oliver](https://discourse.nodered.org/u/oliver)\
**Replies:** 3\
**Last updated:** [15 March 2022 10:25 UTC](https://discourse.nodered.org/t/how-to-change-the-default-marker-icon-in-the-node-red-worldmap-node-from-a-function-node/59812 "2022-03-15T10:25:48Z")

</div>

Hi the default red marker is very large, I wonder if there is a way to change it. I did not find a property in the worldmap node settings. I know it is possible to add it in every record but that is not the way I prefe…

---

## [Add a button to a cell in ui-table](https://discourse.nodered.org/t/add-a-button-to-a-cell-in-ui-table/59876)

<div class="topic-metadata">

**Author:** [@kvramji](https://discourse.nodered.org/u/kvramji)\
**Replies:** 0\
**Last updated:** [15 March 2022 09:25 UTC](https://discourse.nodered.org/t/add-a-button-to-a-cell-in-ui-table/59876 "2022-03-15T09:25:20Z")

</div>

I was wondering if i can add buttons to a column in a table on node red dashboard. I have used the ui-table node and it works well. I see a lot of options like progress bar and star ratings, etc. Can someone help me on…

---

## [Pass data throught a button to SQL Table](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649)

<div class="topic-metadata">

**Author:** [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Replies:** 27\
**Last updated:** [15 March 2022 09:09 UTC](https://discourse.nodered.org/t/pass-data-throught-a-button-to-sql-table/59649 "2022-03-15T09:09:55Z")

</div>

Hello! I have created a UI like this: \</\> When I press the button 'CARICA' I would insert the inserted data to an SQL table (already created). Which flow can I use? How can I pass inserted data to the SQL table (I…

---

## [NodeRed Spotify control](https://discourse.nodered.org/t/nodered-spotify-control/59873)

<div class="topic-metadata">

**Author:** [@thibo.vonderlynck](https://discourse.nodered.org/u/thibo.vonderlynck)\
**Replies:** 3\
**Last updated:** [15 March 2022 09:07 UTC](https://discourse.nodered.org/t/nodered-spotify-control/59873 "2022-03-15T09:07:05Z")

</div>

Hi everyone, I'm having some questions about NodeRed. So basically I'm sending over the Spotify song name to a broker called HiveMQ. The goal is to then get it sent over to an ESP32 and get it printed on an LCD screen. T…

---

## [Entity could not be found in cache](https://discourse.nodered.org/t/entity-could-not-be-found-in-cache/59845)

<div class="topic-metadata">

**Author:** [@Luminary](https://discourse.nodered.org/u/Luminary)\
**Replies:** 1\
**Last updated:** [15 March 2022 08:45 UTC](https://discourse.nodered.org/t/entity-could-not-be-found-in-cache/59845 "2022-03-15T08:45:03Z")

</div>

I'm running NR in Home Assistant. I'm trying to set up a flow that will check if we're home at a specific time during the day, and if we are, turn on a light. I've configured current state nodes to check the locations of…

---

## [Nextcloud Oauth 2 Login](https://discourse.nodered.org/t/nextcloud-oauth-2-login/4403)

<div class="topic-metadata">

**Author:** [@dugite-code](https://discourse.nodered.org/u/dugite-code)\
**Replies:** 7\
**Last updated:** [15 March 2022 06:55 UTC](https://discourse.nodered.org/t/nextcloud-oauth-2-login/4403 "2022-03-15T06:55:18Z")

</div>

I'm trying to log into my Node-red instance using Nextcloud 14's new Oath2 implementation. I get through the login with nextcloud and get re-directed to the callback url https://example.tld/node-red/auth/strategy/callba…

---

## [Looks like node-red-contrib-dns has been orphaned, and once you move to node14, install fails?](https://discourse.nodered.org/t/looks-like-node-red-contrib-dns-has-been-orphaned-and-once-you-move-to-node14-install-fails/59857)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 2\
**Last updated:** [15 March 2022 03:54 UTC](https://discourse.nodered.org/t/looks-like-node-red-contrib-dns-has-been-orphaned-and-once-you-move-to-node14-install-fails/59857 "2022-03-15T03:54:03Z")

</div>

Looks like node-red-contrib-dns has been orphaned, and once you move to node 14, install fails? Violates version range, per the package details. I can of course change the package details to force the issue and test. …

---

## [Add array object value from two arrays and return one array with the add values](https://discourse.nodered.org/t/add-array-object-value-from-two-arrays-and-return-one-array-with-the-add-values/59826)

<div class="topic-metadata">

**Author:** [@Gitsaibot](https://discourse.nodered.org/u/Gitsaibot)\
**Replies:** 4\
**Last updated:** [15 March 2022 02:24 UTC](https://discourse.nodered.org/t/add-array-object-value-from-two-arrays-and-return-one-array-with-the-add-values/59826 "2022-03-15T02:24:40Z")

</div>

Hello, is it possible to add an object value from two arrays without changing the other objects in the array? The two arrays should become one array.

---

## [Dashboard ui dies](https://discourse.nodered.org/t/dashboard-ui-dies/59860)

<div class="topic-metadata">

**Author:** [@leifnel](https://discourse.nodered.org/u/leifnel)\
**Replies:** 2\
**Last updated:** [14 March 2022 23:23 UTC](https://discourse.nodered.org/t/dashboard-ui-dies/59860 "2022-03-14T23:23:37Z")

</div>

I'm running node-red in docker. Sometimes the dashboard dies (404 in traefik) but the rest keeps working and processing input and produce output. I see nothing in the log which gives any hints of the dashboard is dead. …

---

## [High CPU usage due to watchdirectory contrib node](https://discourse.nodered.org/t/high-cpu-usage-due-to-watchdirectory-contrib-node/59800)

<div class="topic-metadata">

**Author:** [@CreativeWarlock](https://discourse.nodered.org/u/CreativeWarlock)\
**Replies:** 13\
**Last updated:** [14 March 2022 21:37 UTC](https://discourse.nodered.org/t/high-cpu-usage-due-to-watchdirectory-contrib-node/59800 "2022-03-14T21:37:55Z")

</div>

Just a heads-up in case anyone else has the problem of his/her Node Red using high CPU usage + high LOAD values: Would be great if there's a way to install a throttle or delay cause my Node Red platform became more and…

---

## [Mitsubishi MC Protocol Read Node Not connected or timeout](https://discourse.nodered.org/t/mitsubishi-mc-protocol-read-node-not-connected-or-timeout/59733)

<div class="topic-metadata">

**Author:** [@jts450](https://discourse.nodered.org/u/jts450)\
**Replies:** 24\
**Last updated:** [14 March 2022 20:05 UTC](https://discourse.nodered.org/t/mitsubishi-mc-protocol-read-node-not-connected-or-timeout/59733 "2022-03-14T20:05:51Z")

</div>

I am not able to establish communication to Mitsubishi PLC. here are some of the setup screens on PLC and Read node. I have tried to change some of the node setting and I am yet to establish connection. Any Idea for me t…

---

## [Want to create a Custom Dashboard UI Widget, do I need Angular?](https://discourse.nodered.org/t/want-to-create-a-custom-dashboard-ui-widget-do-i-need-angular/59852)

<div class="topic-metadata">

**Author:** [@studiobox](https://discourse.nodered.org/u/studiobox)\
**Replies:** 4\
**Last updated:** [14 March 2022 17:53 UTC](https://discourse.nodered.org/t/want-to-create-a-custom-dashboard-ui-widget-do-i-need-angular/59852 "2022-03-14T17:53:24Z")

</div>

Hi, If I am going to created custom Dashboard UI Widget, do I need Angular for create UI client side? :thinking:

---

## [How to check user input text is not in already in SQL results](https://discourse.nodered.org/t/how-to-check-user-input-text-is-not-in-already-in-sql-results/59850)

<div class="topic-metadata">

**Author:** [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Replies:** 1\
**Last updated:** [14 March 2022 15:49 UTC](https://discourse.nodered.org/t/how-to-check-user-input-text-is-not-in-already-in-sql-results/59850 "2022-03-14T15:49:53Z")

</div>

Hello Forum, Could you suggest me some post or link where I can see how to make a comparison between an input text and the result of a query made to an SQL table? The result of the query is a column extracted from an S…

---

## [How to change json property with the value in a text input node?](https://discourse.nodered.org/t/how-to-change-json-property-with-the-value-in-a-text-input-node/59835)

<div class="topic-metadata">

**Author:** [@thoraz](https://discourse.nodered.org/u/thoraz)\
**Replies:** 3\
**Last updated:** [14 March 2022 15:25 UTC](https://discourse.nodered.org/t/how-to-change-json-property-with-the-value-in-a-text-input-node/59835 "2022-03-14T15:25:10Z")

</div>

A simple question: how to change json property with the value in a text input node? I have a button node that generates a json object to send via mqtt. Now I want to use a text input node to change the value of data prop…

---

## [Woes with typedInput field and boolean default value](https://discourse.nodered.org/t/woes-with-typedinput-field-and-boolean-default-value/59825)

<div class="topic-metadata">

**Author:** [@tve](https://discourse.nodered.org/u/tve)\
**Replies:** 2\
**Last updated:** [14 March 2022 15:13 UTC](https://discourse.nodered.org/t/woes-with-typedinput-field-and-boolean-default-value/59825 "2022-03-14T15:13:51Z")

</div>

I'm trying to initialize a typedInput field with a boolean value of false, and I'm not managing. I prepared a minimal test-case to show the issue. The node HTML defines falsy values for 4 flags and then creates a typedIn…

---

## [Node Red on openwrt and serial port](https://discourse.nodered.org/t/node-red-on-openwrt-and-serial-port/59837)

<div class="topic-metadata">

**Author:** [@plouc](https://discourse.nodered.org/u/plouc)\
**Replies:** 6\
**Last updated:** [14 March 2022 15:11 UTC](https://discourse.nodered.org/t/node-red-on-openwrt-and-serial-port/59837 "2022-03-14T15:11:53Z")

</div>

Hello, I installed node-red alongside openmtcprouter which is openwrt based. PACKAGE: openmptcprouter VERSION: v0.58.5 TARGET: rpi4 ARCH: aarch64\_cortex-a72 The goal is to add automation on a sy…

---

## [User context in httpAdminMiddleware?](https://discourse.nodered.org/t/user-context-in-httpadminmiddleware/57542)

<div class="topic-metadata">

**Author:** [@mw75](https://discourse.nodered.org/u/mw75)\
**Replies:** 5\
**Last updated:** [14 March 2022 15:00 UTC](https://discourse.nodered.org/t/user-context-in-httpadminmiddleware/57542 "2022-03-14T15:00:30Z")

</div>

Hi all, i'm currently integrating node-red in an OpenID-connect context using keycloak as provider - see OAuth/OpenID logout with Keycloak . In this context i found the httpAdminMiddleware settings and tried it out. I …

---

## [Plotting values wont work](https://discourse.nodered.org/t/plotting-values-wont-work/59829)

<div class="topic-metadata">

**Author:** [@Olivia](https://discourse.nodered.org/u/Olivia)\
**Replies:** 5\
**Last updated:** [14 March 2022 13:49 UTC](https://discourse.nodered.org/t/plotting-values-wont-work/59829 "2022-03-14T13:49:10Z")

</div>

Hello evryone, i have a script where i wanna print the output. I tried many things, from a chart to a table but i cant print the output. i prefer to see te values is a linechart. but i thing it will be to difficult to …

---

## [Docker NodeRed on Unraid Applestreudal File Path](https://discourse.nodered.org/t/docker-nodered-on-unraid-applestreudal-file-path/59823)

<div class="topic-metadata">

**Author:** [@CAL37](https://discourse.nodered.org/u/CAL37)\
**Replies:** 6\
**Last updated:** [14 March 2022 13:09 UTC](https://discourse.nodered.org/t/docker-nodered-on-unraid-applestreudal-file-path/59823 "2022-03-14T13:09:58Z")

</div>

Does anyone run Node-Red using docker on Unraid? I'm trying to authenticate my Alexa and have narrowed it down to possibly being a access issue to save the cookie. I tried to see if I could just get to /mnt, but got EISD…

---

## [Merge/Join 2 messages](https://discourse.nodered.org/t/merge-join-2-messages/59840)

<div class="topic-metadata">

**Author:** [@SplitSecComp](https://discourse.nodered.org/u/SplitSecComp)\
**Replies:** 2\
**Last updated:** [14 March 2022 13:09 UTC](https://discourse.nodered.org/t/merge-join-2-messages/59840 "2022-03-14T13:09:18Z")

</div>

Hi. I am trying to merge or join the 2 messages in to one but one is an object and one is a string. The join nodes does not work. How can i join merge these two messages i have tried everything but no success. The f…

---

## [ISSUE with storing MQTT values to mySQL database : the values store as "undefined". Any guidence is much appreciated](https://discourse.nodered.org/t/issue-with-storing-mqtt-values-to-mysql-database-the-values-store-as-undefined-any-guidence-is-much-appreciated/59811)

<div class="topic-metadata">

**Author:** [@Evan7](https://discourse.nodered.org/u/Evan7)\
**Replies:** 9\
**Last updated:** [14 March 2022 13:08 UTC](https://discourse.nodered.org/t/issue-with-storing-mqtt-values-to-mysql-database-the-values-store-as-undefined-any-guidence-is-much-appreciated/59811 "2022-03-14T13:08:52Z")

</div>

DEBUG WINDOW: INSERT INTO readingsreceived(ssid,rssi,scan\_mac,sensor\_mac)VALUES('undefined','NaN','undefined','undefined'); : msg.payload : ResultSetHeader "\[object Object\]" FUNCTION NODE QUERY: ssid = msg.payload.ssi…

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

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