# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=223

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

**Page:** 224

---

## [User Input start date and stop date, and how to extract data from the sql according to dates](https://discourse.nodered.org/t/user-input-start-date-and-stop-date-and-how-to-extract-data-from-the-sql-according-to-dates/77378)

<div class="topic-metadata">

**Author:** [@ksthar](https://discourse.nodered.org/u/ksthar)\
**Replies:** 8\
**Last updated:** [9 April 2023 10:54 UTC](https://discourse.nodered.org/t/user-input-start-date-and-stop-date-and-how-to-extract-data-from-the-sql-according-to-dates/77378 "2023-04-09T10:54:25Z")

</div>

Hello everyone, I would like to ask something regarding to take out the data from the mySQL database. I took the start date and stop date with the date picker node. ///////////////////////////////////////////////////…

---

## [\[Flexdash\]: dark theme and b/w text / value color](https://discourse.nodered.org/t/flexdash-dark-theme-and-b-w-text-value-color/77355)

<div class="topic-metadata">

**Author:** [@PLCMercenary](https://discourse.nodered.org/u/PLCMercenary)\
**Replies:** 2\
**Last updated:** [9 April 2023 04:10 UTC](https://discourse.nodered.org/t/flexdash-dark-theme-and-b-w-text-value-color/77355 "2023-04-09T04:10:58Z")

</div>

Hello All, I have tried reading all of the threads and I have been through the flexdash docs several times, and I havent found any discussion about how to either 1) detect that dark mode is selected on client so that wid…

---

## [Best Practices - Subflow versionning between multiple NR instances](https://discourse.nodered.org/t/best-practices-subflow-versionning-between-multiple-nr-instances/77344)

<div class="topic-metadata">

**Author:** [@Barbudor](https://discourse.nodered.org/u/Barbudor)\
**Replies:** 6\
**Last updated:** [8 April 2023 19:28 UTC](https://discourse.nodered.org/t/best-practices-subflow-versionning-between-multiple-nr-instances/77344 "2023-04-08T19:28:00Z")

</div>

Hi everyone We are using multiple NR instances and we have designed a few tenth of subflows to manage API calls to our system + other re-usable pieces of flows. We now have a lot of trouble to manage coherency and vers…

---

## [https://www.reddit.com/r/nodered/comments/bw6o84/gnuroot\_debian/](https://discourse.nodered.org/t/https-www-reddit-com-r-nodered-comments-bw6o84-gnuroot-debian/11785)

<div class="topic-metadata">

**Author:** [@SoumyadeepChatterjee](https://discourse.nodered.org/u/SoumyadeepChatterjee)\
**Replies:** 4\
**Last updated:** [7 April 2023 11:54 UTC](https://discourse.nodered.org/t/https-www-reddit-com-r-nodered-comments-bw6o84-gnuroot-debian/11785 "2023-04-07T11:54:42Z")

</div>

I have got a android device running 4.1.2 and I wanted to use it as a Node-Red server and for that i rooted it and installed GNURoot Debian and now that I ran the commands the nodejs version is not updated enough for the…

---

## [IR Device and Tuya Local](https://discourse.nodered.org/t/ir-device-and-tuya-local/75772)

<div class="topic-metadata">

**Author:** [@meccip](https://discourse.nodered.org/u/meccip)\
**Replies:** 1\
**Last updated:** [7 April 2023 17:18 UTC](https://discourse.nodered.org/t/ir-device-and-tuya-local/75772 "2023-04-07T17:18:35Z")

</div>

Hello, I have a S06ProWB3S IR Device with temperature and humidity. I use it with Tuya and i control my air conditioner and tv from tuya app. I try to use it with nodered to start my AC when I get to much power from my …

---

## [How to properly handle node.done()](https://discourse.nodered.org/t/how-to-properly-handle-node-done/77315)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 19\
**Last updated:** [8 April 2023 14:17 UTC](https://discourse.nodered.org/t/how-to-properly-handle-node-done/77315 "2023-04-08T14:17:39Z")

</div>

I'm a little confused about node.done() function and how to use it after a for loop. Let's suppose that I have 10 messages to send async. I must tell nodered the that it has finished due to timeout issues. In my exampl…

---

## [There are no new node posts in Mastodon Node-RED Nodes](https://discourse.nodered.org/t/there-are-no-new-node-posts-in-mastodon-node-red-nodes/77334)

<div class="topic-metadata">

**Author:** [@Folgore](https://discourse.nodered.org/u/Folgore)\
**Replies:** 6\
**Last updated:** [7 April 2023 20:33 UTC](https://discourse.nodered.org/t/there-are-no-new-node-posts-in-mastodon-node-red-nodes/77334 "2023-04-07T20:33:36Z")

</div>

Hi @knolleary and @cymplecy(for knowledge) , there is a problem with a new posts @nodes@social.nodered.org Mastodon channel. I receive the news only from twitter. For help, I have used a rss node with certificate expir…

---

## [Accessing external libraries](https://discourse.nodered.org/t/accessing-external-libraries/77340)

<div class="topic-metadata">

**Author:** [@bwims](https://discourse.nodered.org/u/bwims)\
**Replies:** 15\
**Last updated:** [7 April 2023 20:23 UTC](https://discourse.nodered.org/t/accessing-external-libraries/77340 "2023-04-07T20:23:01Z")

</div>

Hello! One for the JS programmers... I can gain access to an external library using the setup tab of the function node and this works well in the case where access is gained either by a "require (module)" or an "import…

---

## [DOMParser https stream](https://discourse.nodered.org/t/domparser-https-stream/77350)

<div class="topic-metadata">

**Author:** [@niclas.w82](https://discourse.nodered.org/u/niclas.w82)\
**Replies:** 2\
**Last updated:** [7 April 2023 19:48 UTC](https://discourse.nodered.org/t/domparser-https-stream/77350 "2023-04-07T19:48:47Z")

</div>

Hi. I have a http Connection that needs to be open and listen to events in realtime. (http stream) Today i use the reuest function to connect to the stream but my problem is that sometimes the xml comes in chunks and i…

---

## [Tuya Smart Device wont hold dps values](https://discourse.nodered.org/t/tuya-smart-device-wont-hold-dps-values/75205)

<div class="topic-metadata">

**Author:** [@Jsimon003](https://discourse.nodered.org/u/Jsimon003)\
**Replies:** 9\
**Last updated:** [7 April 2023 17:44 UTC](https://discourse.nodered.org/t/tuya-smart-device-wont-hold-dps-values/75205 "2023-04-07T17:44:23Z")

</div>

I'm attempting to change the color of my light from its current setting to blue. When i try to set it to blue it sets dps 21 to "colour", then it sets dps 21 to "white", then it sets dps 24 to "333303E803E8" which is blu…

---

## [Dashboard 'button' label normal/capital text](https://discourse.nodered.org/t/dashboard-button-label-normal-capital-text/77339)

<div class="topic-metadata">

**Author:** [@gNeandr](https://discourse.nodered.org/u/gNeandr)\
**Replies:** 2\
**Last updated:** [7 April 2023 17:16 UTC](https://discourse.nodered.org/t/dashboard-button-label-normal-capital-text/77339 "2023-04-07T17:16:25Z")

</div>

The label of a button in the dashboard always seems to use capital letters ... afais!? Need to change the 'label' dynamically with {{msg.payload}}. The generated string has "kWh", but the button on the dashboard shows "…

---

## [Modbus Serial - Best way to request data](https://discourse.nodered.org/t/modbus-serial-best-way-to-request-data/76721)

<div class="topic-metadata">

**Author:** [@thalesmaoa](https://discourse.nodered.org/u/thalesmaoa)\
**Replies:** 4\
**Last updated:** [7 April 2023 16:43 UTC](https://discourse.nodered.org/t/modbus-serial-best-way-to-request-data/76721 "2023-04-07T16:43:39Z")

</div>

Hi, I'm using NodeRed v3.0.2 and node-red-contrib-modbus (last version). My modbus hardware uses a RS485 RTU. After some reading, I noticed that best practice to request data is to make a single request with a higher nu…

---

## [Onkyo volume +5 or -5](https://discourse.nodered.org/t/onkyo-volume-5-or-5/77282)

<div class="topic-metadata">

**Author:** [@schorrie](https://discourse.nodered.org/u/schorrie)\
**Replies:** 10\
**Last updated:** [7 April 2023 15:25 UTC](https://discourse.nodered.org/t/onkyo-volume-5-or-5/77282 "2023-04-07T15:25:51Z")

</div>

I use eiscp out and managed to make a button controlling my volume of the onkyo receiver. I want to make buttons in home assistant for volume up or down, When clicking on it, it first has to read the current volume and…

---

## [How do I get the time from the last point in a Node-red dashboard chart](https://discourse.nodered.org/t/how-do-i-get-the-time-from-the-last-point-in-a-node-red-dashboard-chart/77318)

<div class="topic-metadata">

**Author:** [@alveron](https://discourse.nodered.org/u/alveron)\
**Replies:** 7\
**Last updated:** [7 April 2023 13:09 UTC](https://discourse.nodered.org/t/how-do-i-get-the-time-from-the-last-point-in-a-node-red-dashboard-chart/77318 "2023-04-07T13:09:43Z")

</div>

I have a chart being populated from a datalogger. Sometimes the connection goes bad, so I would like to publish the time of the last plotted point so I can monitor it and potentially act if I have not received data for a…

---

## [Student in need of help Setting up Weather API](https://discourse.nodered.org/t/student-in-need-of-help-setting-up-weather-api/77328)

<div class="topic-metadata">

**Author:** [@JamesIoTStudent](https://discourse.nodered.org/u/JamesIoTStudent)\
**Replies:** 7\
**Last updated:** [7 April 2023 05:54 UTC](https://discourse.nodered.org/t/student-in-need-of-help-setting-up-weather-api/77328 "2023-04-07T05:54:54Z")

</div>

Hello would someone be willing to help me figure out how to add the weather service api so I can see it in a dashboard?

---

## [Mustache Template to create array of objects](https://discourse.nodered.org/t/mustache-template-to-create-array-of-objects/77326)

<div class="topic-metadata">

**Author:** [@KSum](https://discourse.nodered.org/u/KSum)\
**Replies:** 6\
**Last updated:** [6 April 2023 21:53 UTC](https://discourse.nodered.org/t/mustache-template-to-create-array-of-objects/77326 "2023-04-06T21:53:55Z")

</div>

Hello, I have the need to take data from the array, msg.payload.devices and reformat it to msg.options as an array of objects. I am trying to use a Template node and mustache template to do so, but am having an issue. …

---

## [Trouble sending data to TTN Device Downlink via MQTT Out](https://discourse.nodered.org/t/trouble-sending-data-to-ttn-device-downlink-via-mqtt-out/77288)

<div class="topic-metadata">

**Author:** [@NewToNodeRed](https://discourse.nodered.org/u/NewToNodeRed)\
**Replies:** 1\
**Last updated:** [6 April 2023 20:22 UTC](https://discourse.nodered.org/t/trouble-sending-data-to-ttn-device-downlink-via-mqtt-out/77288 "2023-04-06T20:22:20Z")

</div>

I a looking to troubleshoot sending commands to my downlink of my device on the TTN network. In the TTN console I do this and it works: But from Node Red I have the following in a function feeding into a MQTT Out and…

---

## [Can not input the openweather API key in the node](https://discourse.nodered.org/t/can-not-input-the-openweather-api-key-in-the-node/77304)

<div class="topic-metadata">

**Author:** [@Percy](https://discourse.nodered.org/u/Percy)\
**Replies:** 3\
**Last updated:** [6 April 2023 18:57 UTC](https://discourse.nodered.org/t/can-not-input-the-openweather-api-key-in-the-node/77304 "2023-04-06T18:57:10Z")

</div>

Hi, I am working on a project that using openweather node to display the weather. I have got a problem which is there is no space to input the API key so I can't display the weather in the dashboard. I have re-downloade…

---

## [AWS Terraform Windows with Node-Red](https://discourse.nodered.org/t/aws-terraform-windows-with-node-red/36706)

<div class="topic-metadata">

**Author:** [@mrSidX](https://discourse.nodered.org/u/mrSidX)\
**Replies:** 14\
**Last updated:** [6 April 2023 16:27 UTC](https://discourse.nodered.org/t/aws-terraform-windows-with-node-red/36706 "2023-04-06T16:27:49Z")

</div>

I'm trying to deploy a Windows Server via Terraform that installs Node-RED, It gets to the script and seems to stop after the nodejs installation. Can't seems to get PATH variables to stick, but when I log into the re…

---

## [Zooming out a chart](https://discourse.nodered.org/t/zooming-out-a-chart/77314)

<div class="topic-metadata">

**Author:** [@Leo](https://discourse.nodered.org/u/Leo)\
**Replies:** 0\
**Last updated:** [6 April 2023 14:26 UTC](https://discourse.nodered.org/t/zooming-out-a-chart/77314 "2023-04-06T14:26:34Z")

</div>

Hi, I've made a chart with a template and a ui\_template node (see flow in addendum). The chart depicts time (x) vs energy(y) over a seven day period. This works fine. Then I want to be able to zoom in on a certain…

---

## [Read SQL data and write to PLC](https://discourse.nodered.org/t/read-sql-data-and-write-to-plc/77278)

<div class="topic-metadata">

**Author:** [@machadof11](https://discourse.nodered.org/u/machadof11)\
**Replies:** 2\
**Last updated:** [6 April 2023 14:05 UTC](https://discourse.nodered.org/t/read-sql-data-and-write-to-plc/77278 "2023-04-06T14:05:00Z")

</div>

Hi, I would like to read a value in SQL server and write it to a Rockwell PLC. With "Inject" node it was possible to write, now I would like to reade (SQL) an write to PLC. Thanks.

---

## [Silly JavaScript question](https://discourse.nodered.org/t/silly-javascript-question/77223)

<div class="topic-metadata">

**Author:** [@drmibell](https://discourse.nodered.org/u/drmibell)\
**Replies:** 5\
**Last updated:** [6 April 2023 13:52 UTC](https://discourse.nodered.org/t/silly-javascript-question/77223 "2023-04-06T13:52:52Z")

</div>

I realize this isn't strictly a Node-RED question, but it came up in designing a validation function for a custom node. I want to test whether a text input represents an integer. I get these results: let v = '3' node.wa…

---

## [Two XML on same payload?](https://discourse.nodered.org/t/two-xml-on-same-payload/77307)

<div class="topic-metadata">

**Author:** [@fmarzocca](https://discourse.nodered.org/u/fmarzocca)\
**Replies:** 7\
**Last updated:** [6 April 2023 12:11 UTC](https://discourse.nodered.org/t/two-xml-on-same-payload/77307 "2023-04-06T12:11:55Z")

</div>

Hi, I have a payload containing two separate XMLs: \<?xml version="1.0" encoding="utf-8"?\>\<BatteryInfo\>\<channelId\>0\</channelId\>\<chargeStatus\>charging\</chargeStatus\>\<adapterStatus\>solarPanel\</adapterStatus\>\<voltage\>4019\</…

---

## [How to send data from Node-red to Electric Screwdriver machine via modbus write?](https://discourse.nodered.org/t/how-to-send-data-from-node-red-to-electric-screwdriver-machine-via-modbus-write/77270)

<div class="topic-metadata">

**Author:** [@boarak](https://discourse.nodered.org/u/boarak)\
**Replies:** 6\
**Last updated:** [6 April 2023 11:21 UTC](https://discourse.nodered.org/t/how-to-send-data-from-node-red-to-electric-screwdriver-machine-via-modbus-write/77270 "2023-04-06T11:21:16Z")

</div>

Hello again! I hope we can solve this problem together. Sorry for disturbing again. I can take values from my electric screwdriver. I used the Modbus-read command for that. But I would like to vice versa now. I have 4 di…

---

## [Add Broker credentials manager on the dashboard?](https://discourse.nodered.org/t/add-broker-credentials-manager-on-the-dashboard/77283)

<div class="topic-metadata">

**Author:** [@LuisPereira](https://discourse.nodered.org/u/LuisPereira)\
**Replies:** 8\
**Last updated:** [6 April 2023 11:16 UTC](https://discourse.nodered.org/t/add-broker-credentials-manager-on-the-dashboard/77283 "2023-04-06T11:16:16Z")

</div>

Hi Is there a way to allow the dashboard user to add a mqtt broker without having to entering the editor and edit the broker node? In other words, could you push the server host + user name and password to a broker nod…

---

## [Rtsp live stream gets delayed overtime](https://discourse.nodered.org/t/rtsp-live-stream-gets-delayed-overtime/77211)

<div class="topic-metadata">

**Author:** [@edje11](https://discourse.nodered.org/u/edje11)\
**Replies:** 6\
**Last updated:** [6 April 2023 10:26 UTC](https://discourse.nodered.org/t/rtsp-live-stream-gets-delayed-overtime/77211 "2023-04-06T10:26:30Z")

</div>

I'm using @kevinGodell his nodes for my cctv cameras now for a couple of years with great joy. Bought myself an Reolink doorbel last week and integrated (rtsp stream) this also with Kevin his nodes in my dashboard and B…

---

## [Data processing from the heart sensor](https://discourse.nodered.org/t/data-processing-from-the-heart-sensor/77302)

<div class="topic-metadata">

**Author:** [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Replies:** 1\
**Last updated:** [6 April 2023 08:55 UTC](https://discourse.nodered.org/t/data-processing-from-the-heart-sensor/77302 "2023-04-06T08:55:45Z")

</div>

I receive data from a heart sensor like this "22,76,55,4" (Byte 0 - flags: 22 (0001 0110); 71 is the number of heart beats per minute; 137, 3 are two RR-Interval numbers that must be summed in binary, converted to decima…

---

## [Problem adding decimal to variable in function](https://discourse.nodered.org/t/problem-adding-decimal-to-variable-in-function/77194)

<div class="topic-metadata">

**Author:** [@ksga](https://discourse.nodered.org/u/ksga)\
**Replies:** 7\
**Last updated:** [6 April 2023 08:41 UTC](https://discourse.nodered.org/t/problem-adding-decimal-to-variable-in-function/77194 "2023-04-06T08:41:05Z")

</div>

Hi I have a small problem getting a function to increment a value with decimals and not just whole numbers. If I change "BKSerPointStep" to an integer - the function does what I would expect. I tried adding parseFloat …

---

## [Eiscp in and eiscp out status](https://discourse.nodered.org/t/eiscp-in-and-eiscp-out-status/77299)

<div class="topic-metadata">

**Author:** [@schorrie](https://discourse.nodered.org/u/schorrie)\
**Replies:** 1\
**Last updated:** [6 April 2023 08:28 UTC](https://discourse.nodered.org/t/eiscp-in-and-eiscp-out-status/77299 "2023-04-06T08:28:40Z")

</div>

I'm using eiscp-in and eiscp-out nodes in my node red connected to my Onkyo stereo when looking at my nodes, the status is going from connected to disconnected every few seconds when pinging the ip from my browser, no …

---

## [Control roller blinds using the google home assistant](https://discourse.nodered.org/t/control-roller-blinds-using-the-google-home-assistant/77267)

<div class="topic-metadata">

**Author:** [@Skruttiss](https://discourse.nodered.org/u/Skruttiss)\
**Replies:** 2\
**Last updated:** [6 April 2023 08:20 UTC](https://discourse.nodered.org/t/control-roller-blinds-using-the-google-home-assistant/77267 "2023-04-06T08:20:40Z")

</div>

I want to control a motor that only has + - so i need to change polarity but i dont know how to do that whit out making a short circiut. This is my wiring diagram down bellow. My second problem is that i dont have a…

[Previous page](https://discourse.nodered.org/c/general/7.md?page=222)

[Next page](https://discourse.nodered.org/c/general/7.md?page=224)