# Latest

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

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

**Page:** 411

---

## [Neo4jError: Pool is closed, it is no more able to serve requests](https://discourse.nodered.org/t/neo4jerror-pool-is-closed-it-is-no-more-able-to-serve-requests/74250)

<div class="topic-metadata">

**Author:** [@flipzz](https://discourse.nodered.org/u/flipzz)\
**Replies:** 2\
**Last updated:** [27 January 2023 12:18 UTC](https://discourse.nodered.org/t/neo4jerror-pool-is-closed-it-is-no-more-able-to-serve-requests/74250 "2023-01-27T12:18:22Z")

</div>

Hi, I am using node-red-contrib-neo4j-bolt to create new entries in neo4j. After Node RED has been running for a while I get this error message: "Neo4jError: Pool is closed, it is no more able to serve requests.". Any …

---

## [Elementary math, how to solve this?](https://discourse.nodered.org/t/elementary-math-how-to-solve-this/74231)

<div class="topic-metadata">

**Author:** [@devifast](https://discourse.nodered.org/u/devifast)\
**Replies:** 10\
**Last updated:** [27 January 2023 10:17 UTC](https://discourse.nodered.org/t/elementary-math-how-to-solve-this/74231 "2023-01-27T10:17:53Z")

</div>

var real\_pH = "real pH"; var pHSlope = msg.payload.pHSlope; var pH\_current = msg.payload.current; real\_pH =pHSlope - pH\_current; msg.topic = "pH"; return real\_pH; function do nothing return., sorry for my english. Some…

---

## [MySQL node, how to query "equal to or more"?](https://discourse.nodered.org/t/mysql-node-how-to-query-equal-to-or-more/74226)

<div class="topic-metadata">

**Author:** [@network\_potato](https://discourse.nodered.org/u/network_potato)\
**Replies:** 2\
**Last updated:** [27 January 2023 09:30 UTC](https://discourse.nodered.org/t/mysql-node-how-to-query-equal-to-or-more/74226 "2023-01-27T09:30:31Z")

</div>

I am using node-red-node-mysql to query a database. I want to return only the rows where the column number has a value of 5 or more. msg.payload = \['\>=5'\] msg.topic = "SELECT \* FROM myTable WHERE number = ?;" return …

---

## [When data comes in from both SignalK and gpsd how do I proritize SignalK?](https://discourse.nodered.org/t/when-data-comes-in-from-both-signalk-and-gpsd-how-do-i-proritize-signalk/74130)

<div class="topic-metadata">

**Author:** [@Mastiff](https://discourse.nodered.org/u/Mastiff)\
**Replies:** 8\
**Last updated:** [27 January 2023 08:37 UTC](https://discourse.nodered.org/t/when-data-comes-in-from-both-signalk-and-gpsd-how-do-i-proritize-signalk/74130 "2023-01-27T08:37:42Z")

</div>

In my boat I get the position both from SignalK and from gpsd, and the SignalK data from the plotter is much more accurate than the cheap USB GPS mouse I have. The main function of that is so that I can see wher the boat…

---

## [Is there any way to inject no.2 working immediately after I injected inject no.1 (Fins Protocol)](https://discourse.nodered.org/t/is-there-any-way-to-inject-no-2-working-immediately-after-i-injected-inject-no-1-fins-protocol/74245)

<div class="topic-metadata">

**Author:** [@khunakon](https://discourse.nodered.org/u/khunakon)\
**Replies:** 3\
**Last updated:** [27 January 2023 07:51 UTC](https://discourse.nodered.org/t/is-there-any-way-to-inject-no-2-working-immediately-after-i-injected-inject-no-1-fins-protocol/74245 "2023-01-27T07:51:29Z")

</div>

Is there any way when I want inject node no.2 to run immediately after I injected inject no.1 ? my work is about cx-programmer to OMRON PLC, then connect to node-red via fins protocol For example, a project that I am wo…

---

## [Unexpected Characters on RS485 Data Stream](https://discourse.nodered.org/t/unexpected-characters-on-rs485-data-stream/74191)

<div class="topic-metadata">

**Author:** [@Gump](https://discourse.nodered.org/u/Gump)\
**Replies:** 5\
**Last updated:** [27 January 2023 07:17 UTC](https://discourse.nodered.org/t/unexpected-characters-on-rs485-data-stream/74191 "2023-01-27T07:17:03Z")

</div>

I'm brand new to Node-RED and RS485. I'm looking at an incoming RS485 data stream from a Cummins-Onan generator, hoping to eventually decode it. The RS485 lines are connected to a DTech USB adapter, then to my windows …

---

## [Extract \\n from a string to build an array](https://discourse.nodered.org/t/extract-n-from-a-string-to-build-an-array/74196)

<div class="topic-metadata">

**Author:** [@Shadow20X6](https://discourse.nodered.org/u/Shadow20X6)\
**Replies:** 27\
**Last updated:** [27 January 2023 00:53 UTC](https://discourse.nodered.org/t/extract-n-from-a-string-to-build-an-array/74196 "2023-01-27T00:53:13Z")

</div>

I'm sure I'm making some obvious mistake, but wanted to check here before I start writing code in a function block. I have a string with \\n characters with in it. I have that set as the payload, and figured I could hav…

---

## [Default name of Join and Batch nodes](https://discourse.nodered.org/t/default-name-of-join-and-batch-nodes/74212)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 1\
**Last updated:** [26 January 2023 22:18 UTC](https://discourse.nodered.org/t/default-name-of-join-and-batch-nodes/74212 "2023-01-26T22:18:36Z")

</div>

A suggestion to tweek the default name for the batch node: In "no of messages" mode include the number of messages batched. So "batch 3" instead of just "batch" In "time interval" mode include the interval and unit "…

---

## ["TypeError: Cannot create property 'records' on string](https://discourse.nodered.org/t/typeerror-cannot-create-property-records-on-string/73995)

<div class="topic-metadata">

**Author:** [@subbu.kobra](https://discourse.nodered.org/u/subbu.kobra)\
**Replies:** 2\
**Last updated:** [26 January 2023 22:08 UTC](https://discourse.nodered.org/t/typeerror-cannot-create-property-records-on-string/73995 "2023-01-26T22:08:23Z")

</div>

Hi, I am brand new to node-red. I am trying to get contacts from Salesforce using SOQL node. After following few sites, I finally able to create a successful connection with salesforce. However, at the end I am getting …

---

## [Communicate with Ethernet/IP non PLC device](https://discourse.nodered.org/t/communicate-with-ethernet-ip-non-plc-device/74235)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 0\
**Last updated:** [26 January 2023 21:59 UTC](https://discourse.nodered.org/t/communicate-with-ethernet-ip-non-plc-device/74235 "2023-01-26T21:59:57Z")

</div>

Hi there, I've been using Codesys to communicate with Cube 67 Ethernet/IP from Murr Elektronics, but I want to do it straight from NodeRed. The problem is that I have no idea how to perform it. I've been trying to fin…

---

## [Error with MYSQL 2 - Status - crash NODE-RED](https://discourse.nodered.org/t/error-with-mysql-2-status-crash-node-red/74224)

<div class="topic-metadata">

**Author:** [@allacmc](https://discourse.nodered.org/u/allacmc)\
**Replies:** 8\
**Last updated:** [26 January 2023 20:49 UTC](https://discourse.nodered.org/t/error-with-mysql-2-status-crash-node-red/74224 "2023-01-26T20:49:01Z")

</div>

I'm using NODE MYSQL2 as a connection to my database. I put it in a subflow. I added an OUTPUT Status. But when you have this option, it completely crashes NODE-RED and I need to manually restart. \[{"id":"4639c7fa…

---

## [How to lock the access to http://127.0.0.1:1880/#flow/](https://discourse.nodered.org/t/how-to-lock-the-access-to-http-127-0-0-1-1880-flow/74230)

<div class="topic-metadata">

**Author:** [@JorgeGomes](https://discourse.nodered.org/u/JorgeGomes)\
**Replies:** 1\
**Last updated:** [26 January 2023 20:30 UTC](https://discourse.nodered.org/t/how-to-lock-the-access-to-http-127-0-0-1-1880-flow/74230 "2023-01-26T20:30:39Z")

</div>

Hello Community, I'm creating a node-red flow with a dashboard that will be used for several people, and my idea is only to give the access to http://127.0.0.1:1880/ui/ to avoid that the development part can be changed. …

---

## [Uibuilder - first "official" video](https://discourse.nodered.org/t/uibuilder-first-official-video/74015)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 10\
**Last updated:** [26 January 2023 17:43 UTC](https://discourse.nodered.org/t/uibuilder-first-official-video/74015 "2023-01-26T17:43:07Z")

</div>

I know folk have sometimes asked for videos explaining how to use uibuilder. Well, here is the first from me. :grin: It isn't very good I'm afraid and was somewhat spur of the moment. I also need to learn …

---

## [Failed installing node-red-contrib-ble-sense](https://discourse.nodered.org/t/failed-installing-node-red-contrib-ble-sense/74214)

<div class="topic-metadata">

**Author:** [@Theo\_13](https://discourse.nodered.org/u/Theo_13)\
**Replies:** 11\
**Last updated:** [26 January 2023 16:41 UTC](https://discourse.nodered.org/t/failed-installing-node-red-contrib-ble-sense/74214 "2023-01-26T16:41:08Z")

</div>

Hello everybody, It's my first post here ! I'm trying to install a new node on my computer when this error message appears "Failed to install : node-red-contrib-ble-sense". It is proposed to check the log, and I don…

---

## [JSON global variables in the CHANGE node](https://discourse.nodered.org/t/json-global-variables-in-the-change-node/74216)

<div class="topic-metadata">

**Author:** [@allacmc](https://discourse.nodered.org/u/allacmc)\
**Replies:** 2\
**Last updated:** [26 January 2023 14:50 UTC](https://discourse.nodered.org/t/json-global-variables-in-the-change-node/74216 "2023-01-26T14:50:29Z")

</div>

Is there a smarter way to prepare this JSON? I would like all this to be in a single node CHANGE ? \[{"id":"effa65099dd2a525","type":"function","z":"ea86445f05051d5d","name":"prep\_MQTT\_Conn","func":"\\nconst ip = msg…

---

## [Activate the trigger only once](https://discourse.nodered.org/t/activate-the-trigger-only-once/74131)

<div class="topic-metadata">

**Author:** [@Bomber75](https://discourse.nodered.org/u/Bomber75)\
**Replies:** 6\
**Last updated:** [26 January 2023 13:46 UTC](https://discourse.nodered.org/t/activate-the-trigger-only-once/74131 "2023-01-26T13:46:18Z")

</div>

Hello everybody, with home assistant I control a temperature sensor, the object checks if the temperature is lower than 20, then turn on a relay. The problem is this: when the temperature drops below 20 the object ac…

---

## [MYSQL2 - Dynamic info - Open or Closed Sessions?](https://discourse.nodered.org/t/mysql2-dynamic-info-open-or-closed-sessions/73934)

<div class="topic-metadata">

**Author:** [@allacmc](https://discourse.nodered.org/u/allacmc)\
**Replies:** 13\
**Last updated:** [26 January 2023 13:36 UTC](https://discourse.nodered.org/t/mysql2-dynamic-info-open-or-closed-sessions/73934 "2023-01-26T13:36:08Z")

</div>

I've recently been on a mission to make a system where the implementation of the system won't be mine. It will be a third-party team. So I need to make a system that will be configured by someone else. In this case, I…

---

## [\[Announce\] node-red-contrib-personal-wake-word](https://discourse.nodered.org/t/announce-node-red-contrib-personal-wake-word/39992)

<div class="topic-metadata">

**Author:** [@JGKK](https://discourse.nodered.org/u/JGKK)\
**Replies:** 22\
**Last updated:** [26 January 2023 13:28 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-personal-wake-word/39992 "2023-01-26T13:28:39Z")

</div>

Hello, I’d like to introduce: This node brings integration of the awesome node-personal-wakeword module to nodered. This enables an easy to use key word spotter for use as a personal wake-word in diy voice projects …

---

## [Bunching mqtt data before passing to next node](https://discourse.nodered.org/t/bunching-mqtt-data-before-passing-to-next-node/74208)

<div class="topic-metadata">

**Author:** [@Leo](https://discourse.nodered.org/u/Leo)\
**Replies:** 8\
**Last updated:** [26 January 2023 13:26 UTC](https://discourse.nodered.org/t/bunching-mqtt-data-before-passing-to-next-node/74208 "2023-01-26T13:26:10Z")

</div>

Hi there, I have an mqtt in node that receives every second a value which is send into a function node. Now I want to get 60 values (every minute) from the mqtt, average them and only send the average to an influx data…

---

## [Checking number encoding?](https://discourse.nodered.org/t/checking-number-encoding/74181)

<div class="topic-metadata">

**Author:** [@Dyslexicbloke](https://discourse.nodered.org/u/Dyslexicbloke)\
**Replies:** 7\
**Last updated:** [26 January 2023 11:31 UTC](https://discourse.nodered.org/t/checking-number-encoding/74181 "2023-01-26T11:31:59Z")

</div>

Hi folks, I have been messing with Modbus coms and have it working now. However I am using buffer objects to change between number formats and realised I don't know how to check what format a number in node red actuall…

---

## [How to parse message parts to variables](https://discourse.nodered.org/t/how-to-parse-message-parts-to-variables/74192)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 23\
**Last updated:** [26 January 2023 11:31 UTC](https://discourse.nodered.org/t/how-to-parse-message-parts-to-variables/74192 "2023-01-26T11:31:08Z")

</div>

Sorry folks, I'm stuck again. Story: I have a message (with a LOT of extra stuff added on to save me using flow context.) and want to use one part to point to another part of the message. eg: So: msg.payload.who …

---

## [String to json array](https://discourse.nodered.org/t/string-to-json-array/74206)

<div class="topic-metadata">

**Author:** [@sahar](https://discourse.nodered.org/u/sahar)\
**Replies:** 9\
**Last updated:** [26 January 2023 11:17 UTC](https://discourse.nodered.org/t/string-to-json-array/74206 "2023-01-26T11:17:29Z")

</div>

hi , I need help again at node red , I have this string at msg.payload (receive from data base as json) "{"id":"2","sensor":"DHT11","value1":"26.20","location":"Office"}{"id":"3","sensor":"DHT11","value1":"26.10","locat…

---

## [Italy:Come Leggere più varabili in OpcUa / English: How to Read multiple variables in OpcUa](https://discourse.nodered.org/t/italy-come-leggere-piu-varabili-in-opcua-english-how-to-read-multiple-variables-in-opcua/72901)

<div class="topic-metadata">

**Author:** [@ahmedt04](https://discourse.nodered.org/u/ahmedt04)\
**Replies:** 1\
**Last updated:** [26 January 2023 09:59 UTC](https://discourse.nodered.org/t/italy-come-leggere-piu-varabili-in-opcua-english-how-to-read-multiple-variables-in-opcua/72901 "2023-01-26T09:59:36Z")

</div>

Italy: ciao, Devo leggere delle variabili tramite Opc Ua ma le variabili sono tante come faccio a leggerle usando pochi nodi? grazie. English: Hello, I have to read some variables through OpcUa but there are so many …

---

## [Trigger node - how to delay and repeat message?](https://discourse.nodered.org/t/trigger-node-how-to-delay-and-repeat-message/74117)

<div class="topic-metadata">

**Author:** [@OliverWieland](https://discourse.nodered.org/u/OliverWieland)\
**Replies:** 17\
**Last updated:** [26 January 2023 09:44 UTC](https://discourse.nodered.org/t/trigger-node-how-to-delay-and-repeat-message/74117 "2023-01-26T09:44:08Z")

</div>

Hi! I want to set a trigger node to do the following: On message do nothing Send the received message every 10 seconds, until the reset criteria is fulfilled. So I set "Send" to "nothing" and "then" to "resend it eve…

---

## [Indoor Navigation Positioning rssi](https://discourse.nodered.org/t/indoor-navigation-positioning-rssi/74123)

<div class="topic-metadata">

**Author:** [@ankit.prasad](https://discourse.nodered.org/u/ankit.prasad)\
**Replies:** 2\
**Last updated:** [26 January 2023 09:07 UTC](https://discourse.nodered.org/t/indoor-navigation-positioning-rssi/74123 "2023-01-26T09:07:19Z")

</div>

If we have more than 4 bluetooth ble beacons and we have placed it in a room on 4 different walls, using rssi value can we find the user position inside a room , having a mobile app scanning all 4 beacons rssi ? Is ther…

---

## [Just to show what I've been doing lately with \`subflows\` and stuff](https://discourse.nodered.org/t/just-to-show-what-ive-been-doing-lately-with-subflows-and-stuff/74194)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 0\
**Last updated:** [26 January 2023 00:01 UTC](https://discourse.nodered.org/t/just-to-show-what-ive-been-doing-lately-with-subflows-and-stuff/74194 "2023-01-26T00:01:44Z")

</div>

I am sorry for all the recent stupid questions I've been asking. I was writing some code to do some graphical animations when devices need to be charged. This is the flow - you will have to set some flow.context stuff,…

---

## [Remove palette option missing!](https://discourse.nodered.org/t/remove-palette-option-missing/74187)

<div class="topic-metadata">

**Author:** [@e-labInnovations](https://discourse.nodered.org/u/e-labInnovations)\
**Replies:** 4\
**Last updated:** [26 January 2023 09:03 UTC](https://discourse.nodered.org/t/remove-palette-option-missing/74187 "2023-01-26T09:03:05Z")

</div>

When I use Storage API (storageModule) for using a PostgreSQL database, I lose the option to remove the palette. How to get the remove the palette option?

---

## [Display remaining trigger flow time and extend trigger time](https://discourse.nodered.org/t/display-remaining-trigger-flow-time-and-extend-trigger-time/74179)

<div class="topic-metadata">

**Author:** [@tmollow](https://discourse.nodered.org/u/tmollow)\
**Replies:** 2\
**Last updated:** [26 January 2023 08:35 UTC](https://discourse.nodered.org/t/display-remaining-trigger-flow-time-and-extend-trigger-time/74179 "2023-01-26T08:35:30Z")

</div>

A small electric heater is to be controlled with Node-Red. A gate flow is used and the runtime is controlled via a trigger node. I am still missing 2 properties: The trigger is controlled via a button and then runs fo…

---

## [Html node output not what I expect](https://discourse.nodered.org/t/html-node-output-not-what-i-expect/74195)

<div class="topic-metadata">

**Author:** [@gerry](https://discourse.nodered.org/u/gerry)\
**Replies:** 1\
**Last updated:** [26 January 2023 01:50 UTC](https://discourse.nodered.org/t/html-node-output-not-what-i-expect/74195 "2023-01-26T01:50:59Z")

</div>

On another Pi this flow and node were working as expected. Of course not willing to leave it alone I traded out the Pi for another one and reloaded the flow. Now, instead of an output I get an empty array. Color me baffl…

---

## [Noob Q: What's the code to access this data?](https://discourse.nodered.org/t/noob-q-whats-the-code-to-access-this-data/74067)

<div class="topic-metadata">

**Author:** [@bacontexas](https://discourse.nodered.org/u/bacontexas)\
**Replies:** 6\
**Last updated:** [26 January 2023 00:53 UTC](https://discourse.nodered.org/t/noob-q-whats-the-code-to-access-this-data/74067 "2023-01-26T00:53:16Z")

</div>

I'm a Java noob and I have spent an hour googling to try to figure out how I access the value 125.5 in a payload represented below. I tried payload.solar\_power.value and payload.solar\_power\['value'\] but no luck. I don'…

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

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