# General

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

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

**Page:** 274

---

## [Postgres write timestamp error](https://discourse.nodered.org/t/postgres-write-timestamp-error/72643)

<div class="topic-metadata">

**Author:** [@kgakere](https://discourse.nodered.org/u/kgakere)\
**Replies:** 7\
**Last updated:** [25 December 2022 08:01 UTC](https://discourse.nodered.org/t/postgres-write-timestamp-error/72643 "2022-12-25T08:01:25Z")

</div>

Hi, i have a postgesdb that i am trying to inject a timestamp into a column. I have used a function node to convert the time to an appropriate format but still have errors. Kindly assist; error: syntax error at…

---

## [Error npm install](https://discourse.nodered.org/t/error-npm-install/72672)

<div class="topic-metadata">

**Author:** [@black5cat](https://discourse.nodered.org/u/black5cat)\
**Replies:** 13\
**Last updated:** [25 December 2022 00:13 UTC](https://discourse.nodered.org/t/error-npm-install/72672 "2022-12-25T00:13:37Z")

</div>

at any attempt to remove nodes from the palette. or install. update .... gives this series of errors, only the name of the node request is changed Node-RED Current version: 14.0.0 Home Assistant 2022.12.8 Supervisor …

---

## [Guess this is java related: datetime](https://discourse.nodered.org/t/guess-this-is-java-related-datetime/72656)

<div class="topic-metadata">

**Author:** [@AndKe](https://discourse.nodered.org/u/AndKe)\
**Replies:** 10\
**Last updated:** [24 December 2022 22:00 UTC](https://discourse.nodered.org/t/guess-this-is-java-related-datetime/72656 "2022-12-24T22:00:42Z")

</div>

I am trying to populate a mysql field that expects datetime. my server is configured for normal 24h system: $ date lø. 24. des. 10:50:41 +0100 2022 I tried to follow this example: https://flows.nodered.org/flow/59fe25…

---

## [Detect Serial Communication fault](https://discourse.nodered.org/t/detect-serial-communication-fault/72507)

<div class="topic-metadata">

**Author:** [@Johrdan](https://discourse.nodered.org/u/Johrdan)\
**Replies:** 4\
**Last updated:** [24 December 2022 18:53 UTC](https://discourse.nodered.org/t/detect-serial-communication-fault/72507 "2022-12-24T18:53:19Z")

</div>

Hi, I am using Node-RED to connect my laptop to a device that has serial communication and is connected to COM2. I am receiving the data in Node-RED through a serial in node and showing the data in a webpage by using uib…

---

## [Node Red deCONZ in-nodes not recognizing nodes established in deCONZ App](https://discourse.nodered.org/t/node-red-deconz-in-nodes-not-recognizing-nodes-established-in-deconz-app/72665)

<div class="topic-metadata">

**Author:** [@ScottJ2505](https://discourse.nodered.org/u/ScottJ2505)\
**Replies:** 0\
**Last updated:** [24 December 2022 16:32 UTC](https://discourse.nodered.org/t/node-red-deconz-in-nodes-not-recognizing-nodes-established-in-deconz-app/72665 "2022-12-24T16:32:17Z")

</div>

\*\*Hi, I have been using Node Red with deCONZ successfully for quite some time in Windows 10. I ran into a problem I have not seen before and am hoping others who use deCONZ with Node Red can offer advice to fix the prob…

---

## [Sending mail using a boolean input](https://discourse.nodered.org/t/sending-mail-using-a-boolean-input/72661)

<div class="topic-metadata">

**Author:** [@emil\_m](https://discourse.nodered.org/u/emil_m)\
**Replies:** 0\
**Last updated:** [24 December 2022 15:47 UTC](https://discourse.nodered.org/t/sending-mail-using-a-boolean-input/72661 "2022-12-24T15:47:43Z")

</div>

Hello. I have a small problem: I am reading data from an Omron NX1P2 CPU through MQTT and what I want is after separating the variables to send mail every X time or if I want, through a boolean in the HMI. and I also hav…

---

## [Waiting for missing types to be registered - node-red-node-email](https://discourse.nodered.org/t/waiting-for-missing-types-to-be-registered-node-red-node-email/72636)

<div class="topic-metadata">

**Author:** [@jmtkelly](https://discourse.nodered.org/u/jmtkelly)\
**Replies:** 9\
**Last updated:** [24 December 2022 15:21 UTC](https://discourse.nodered.org/t/waiting-for-missing-types-to-be-registered-node-red-node-email/72636 "2022-12-24T15:21:48Z")

</div>

I am having problems trying to use the node-red-node-email node. I use the palette manager to download the latest version. The installation process is successful however the nodes do not show up in the node-red left-han…

---

## [Sort an array, get the lowest three values and return the labels from those values](https://discourse.nodered.org/t/sort-an-array-get-the-lowest-three-values-and-return-the-labels-from-those-values/72653)

<div class="topic-metadata">

**Author:** [@sstolk11](https://discourse.nodered.org/u/sstolk11)\
**Replies:** 4\
**Last updated:** [24 December 2022 13:50 UTC](https://discourse.nodered.org/t/sort-an-array-get-the-lowest-three-values-and-return-the-labels-from-those-values/72653 "2022-12-24T13:50:54Z")

</div>

I've got this array with different labels and always different values. I would like to have the three lowest values and return the labels in from of those values. I'm searching my \*ss off but JS and other code programm…

---

## [How can i check if a bulb turn on by regular switch?](https://discourse.nodered.org/t/how-can-i-check-if-a-bulb-turn-on-by-regular-switch/72608)

<div class="topic-metadata">

**Author:** [@Sko](https://discourse.nodered.org/u/Sko)\
**Replies:** 6\
**Last updated:** [23 December 2022 22:17 UTC](https://discourse.nodered.org/t/how-can-i-check-if-a-bulb-turn-on-by-regular-switch/72608 "2022-12-23T22:17:25Z")

</div>

Hi Forum, I m new to home assistant and node-red. I have in a room a regular switch and a smart bulb. The bulb is programmed by "behavior on power" to on. Is it possible to become a payload "on" when i switch with a reg…

---

## [Trying to Launch Windows Application on Remote Windows Based Computer](https://discourse.nodered.org/t/trying-to-launch-windows-application-on-remote-windows-based-computer/72649)

<div class="topic-metadata">

**Author:** [@sagj](https://discourse.nodered.org/u/sagj)\
**Replies:** 1\
**Last updated:** [24 December 2022 01:36 UTC](https://discourse.nodered.org/t/trying-to-launch-windows-application-on-remote-windows-based-computer/72649 "2022-12-24T01:36:40Z")

</div>

Hello Folks! I am trying to launch a windows executable program on a remote computer running MQTTBox app. I have node red installed on sending computer which is also a broker. I have this below setup on the Broker and…

---

## [Database - Help / Advice Needed](https://discourse.nodered.org/t/database-help-advice-needed/72595)

<div class="topic-metadata">

**Author:** [@championc](https://discourse.nodered.org/u/championc)\
**Replies:** 15\
**Last updated:** [23 December 2022 19:50 UTC](https://discourse.nodered.org/t/database-help-advice-needed/72595 "2022-12-23T19:50:10Z")

</div>

Hi all, I want to start saving my daily Solar Generation stats. So I will obviously start with saving a daily total and the date to some form of database - but what would the best one likely be for this - MySQL ? Afte…

---

## [Extract Last BackUp Date from Samba BackUp sensor (HA)?](https://discourse.nodered.org/t/extract-last-backup-date-from-samba-backup-sensor-ha/72604)

<div class="topic-metadata">

**Author:** [@BernardS](https://discourse.nodered.org/u/BernardS)\
**Replies:** 2\
**Last updated:** [23 December 2022 19:14 UTC](https://discourse.nodered.org/t/extract-last-backup-date-from-samba-backup-sensor-ha/72604 "2022-12-23T19:14:58Z")

</div>

Hello fellow NodeRed users, I'm a begginer, so please genltle :slight\_smile: I try to create an alerting system if the BackUp of my HomeAssistant server was not done on time. I have I nightly back-up done via the Samba…

---

## [Issue with amixer "Simple mixer control" - different components in nodered exec node and in terminal](https://discourse.nodered.org/t/issue-with-amixer-simple-mixer-control-different-components-in-nodered-exec-node-and-in-terminal/72632)

<div class="topic-metadata">

**Author:** [@ttavlis](https://discourse.nodered.org/u/ttavlis)\
**Replies:** 2\
**Last updated:** [23 December 2022 15:20 UTC](https://discourse.nodered.org/t/issue-with-amixer-simple-mixer-control-different-components-in-nodered-exec-node-and-in-terminal/72632 "2022-12-23T15:20:28Z")

</div>

Dear all, I have an issue and do not know how to solve it. It seems pretty simple, but I searched everywhere but could not find a solution, and also not derivate any solution. So there we go. I am using a Raspi 4b+ I h…

---

## [Problem: contrib-prib-functions ---Corelationship, Covariance](https://discourse.nodered.org/t/problem-contrib-prib-functions-corelationship-covariance/72633)

<div class="topic-metadata">

**Author:** [@tsuratolya](https://discourse.nodered.org/u/tsuratolya)\
**Replies:** 0\
**Last updated:** [23 December 2022 14:18 UTC](https://discourse.nodered.org/t/problem-contrib-prib-functions-corelationship-covariance/72633 "2022-12-23T14:18:58Z")

</div>

Help get results. I do not understand what is needed to get the result. \[ { "id": "82ca4bd0ff1af07a", "type": "Data Analysis", "z": "eec42e70b4f2e4e6", "name": "Covariance", "…

---

## [Extract rgb value from payload](https://discourse.nodered.org/t/extract-rgb-value-from-payload/72605)

<div class="topic-metadata">

**Author:** [@Loasca](https://discourse.nodered.org/u/Loasca)\
**Replies:** 7\
**Last updated:** [23 December 2022 13:40 UTC](https://discourse.nodered.org/t/extract-rgb-value-from-payload/72605 "2022-12-23T13:40:35Z")

</div>

Good evening, I would like to extract the RGB values from the message below, and use them to change rgb in css data: object entity\_id: "light.bec" state: "on" attributes: object supported\_color\_modes: array\[2\] color\_mod…

---

## [Onkyo - Node Red - still struggling](https://discourse.nodered.org/t/onkyo-node-red-still-struggling/72626)

<div class="topic-metadata">

**Author:** [@schorrie](https://discourse.nodered.org/u/schorrie)\
**Replies:** 0\
**Last updated:** [23 December 2022 11:10 UTC](https://discourse.nodered.org/t/onkyo-node-red-still-struggling/72626 "2022-12-23T11:10:20Z")

</div>

I have an Onkyo HT-R695, according to some device info it's also called TX NR656. I have a function node and an eiscp out node to send the command to the Onkyo code in the function node: msg.payload = "input-select…

---

## [Add switch and button in etable dashboard](https://discourse.nodered.org/t/add-switch-and-button-in-etable-dashboard/72614)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 0\
**Last updated:** [23 December 2022 08:03 UTC](https://discourse.nodered.org/t/add-switch-and-button-in-etable-dashboard/72614 "2022-12-23T08:03:39Z")

</div>

Hi all, I would like add switch or button in each row of ui-etable dashboard this is possible? has someone an example? many thanks in advance

---

## [How to check if an Reference in msg.payload exists?](https://discourse.nodered.org/t/how-to-check-if-an-reference-in-msg-payload-exists/18506)

<div class="topic-metadata">

**Author:** [@UweG](https://discourse.nodered.org/u/UweG)\
**Replies:** 4\
**Last updated:** [22 December 2022 23:12 UTC](https://discourse.nodered.org/t/how-to-check-if-an-reference-in-msg-payload-exists/18506 "2022-12-22T23:12:34Z")

</div>

Sometimes i get following reference in msg.payload and sometimes not. msg.payload.Test How can i check in a function if the reference 'Test' in payload exists or not? payload always exists but sometimes with 'Test' …

---

## [Problems with && in IF-Statement](https://discourse.nodered.org/t/problems-with-in-if-statement/72602)

<div class="topic-metadata">

**Author:** [@Dolewan](https://discourse.nodered.org/u/Dolewan)\
**Replies:** 3\
**Last updated:** [22 December 2022 21:08 UTC](https://discourse.nodered.org/t/problems-with-in-if-statement/72602 "2022-12-22T21:08:33Z")

</div>

Hello I'm originally from the Arduino area, but I'm currently trying my hand at Node-Red because of a semester project. I have already spent a few hours trying to solve the problem. My problem is: I get the status of …

---

## [Extract HTML tag from website](https://discourse.nodered.org/t/extract-html-tag-from-website/72582)

<div class="topic-metadata">

**Author:** [@alinm24](https://discourse.nodered.org/u/alinm24)\
**Replies:** 7\
**Last updated:** [22 December 2022 18:12 UTC](https://discourse.nodered.org/t/extract-html-tag-from-website/72582 "2022-12-22T18:12:35Z")

</div>

Yesterday I discovered Node-RED and it seems it could help me to get data from a Salus IT500 thermostat so I try to extract a tag from thermostat page an i need a "token" that is in an \<input\> field and I need its value. …

---

## [Flow context doesnt work](https://discourse.nodered.org/t/flow-context-doesnt-work/72593)

<div class="topic-metadata">

**Author:** [@Zac](https://discourse.nodered.org/u/Zac)\
**Replies:** 1\
**Last updated:** [22 December 2022 15:38 UTC](https://discourse.nodered.org/t/flow-context-doesnt-work/72593 "2022-12-22T15:38:46Z")

</div>

Hey, when I use in the function-Node the following: flow.xyz = "test"; and then try to get the value with the following in another function-Node: let a = flow.xyz; then my variable "a" is undefined? But when I do t…

---

## [MySQL (Mariadb) INSERT returns msg.payload = "\[object Object\]"](https://discourse.nodered.org/t/mysql-mariadb-insert-returns-msg-payload-object-object/72560)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 5\
**Last updated:** [22 December 2022 14:33 UTC](https://discourse.nodered.org/t/mysql-mariadb-insert-returns-msg-payload-object-object/72560 "2022-12-22T14:33:42Z")

</div>

Using node-red-node-mysql v1.0.3, a simple INSERT - msg.topic = "insert into test (temperature) values (24.3)" The table has an auto-increment primary key - id. I need to know the id of the inserted record. If I feed …

---

## [How to merge arrays from two Modbus fc 1 and fc 3](https://discourse.nodered.org/t/how-to-merge-arrays-from-two-modbus-fc-1-and-fc-3/72570)

<div class="topic-metadata">

**Author:** [@tanavit445](https://discourse.nodered.org/u/tanavit445)\
**Replies:** 3\
**Last updated:** [22 December 2022 12:15 UTC](https://discourse.nodered.org/t/how-to-merge-arrays-from-two-modbus-fc-1-and-fc-3/72570 "2022-12-22T12:15:17Z")

</div>

---

## [Access Control list](https://discourse.nodered.org/t/access-control-list/72567)

<div class="topic-metadata">

**Author:** [@rimjhimbhuyan](https://discourse.nodered.org/u/rimjhimbhuyan)\
**Replies:** 2\
**Last updated:** [22 December 2022 11:54 UTC](https://discourse.nodered.org/t/access-control-list/72567 "2022-12-22T11:54:17Z")

</div>

I have created one to-do list with the access control , where user and admin can add task in the list , but only admin can delete the task not the user , but i don't know where the problem is , in my code the user is can…

---

## [Npm warn to unsupported /not compatible version during installation](https://discourse.nodered.org/t/npm-warn-to-unsupported-not-compatible-version-during-installation/72410)

<div class="topic-metadata">

**Author:** [@irenebear](https://discourse.nodered.org/u/irenebear)\
**Replies:** 10\
**Last updated:** [22 December 2022 08:26 UTC](https://discourse.nodered.org/t/npm-warn-to-unsupported-not-compatible-version-during-installation/72410 "2022-12-22T08:26:15Z")

</div>

Dear Sir, who may concern, I am trying to install node-red on my Ubuntu 22 after nodejs of latest version is installed, but encounter below warn: How to fix it? THX!

---

## [How to "npm install" to a red-node in a docker?](https://discourse.nodered.org/t/how-to-npm-install-to-a-red-node-in-a-docker/72555)

<div class="topic-metadata">

**Author:** [@AndKe](https://discourse.nodered.org/u/AndKe)\
**Replies:** 5\
**Last updated:** [22 December 2022 07:20 UTC](https://discourse.nodered.org/t/how-to-npm-install-to-a-red-node-in-a-docker/72555 "2022-12-22T07:20:55Z")

</div>

My red-node is run via docker. Then I see this addon: node-red-contrib-zigbee2mqtt (node) - Node-RED "npm install" is certainly not something I can do in shell .. so where does this command go?

---

## [NodeRED and InfluxDB - One Measurement more fields](https://discourse.nodered.org/t/nodered-and-influxdb-one-measurement-more-fields/72536)

<div class="topic-metadata">

**Author:** [@Egnos](https://discourse.nodered.org/u/Egnos)\
**Replies:** 11\
**Last updated:** [21 December 2022 20:22 UTC](https://discourse.nodered.org/t/nodered-and-influxdb-one-measurement-more-fields/72536 "2022-12-21T20:22:25Z")

</div>

Hi all, I'm new to the Forum and also to NodeRED. I hope you can help me: I created a container with NodeRED Ver. 1.3.4 and I'm doing various experiments. One of them is to extrapolate the payload of this request from …

---

## [Node Red - Query for an IP cam token](https://discourse.nodered.org/t/node-red-query-for-an-ip-cam-token/72552)

<div class="topic-metadata">

**Author:** [@staebchen0](https://discourse.nodered.org/u/staebchen0)\
**Replies:** 0\
**Last updated:** [21 December 2022 20:14 UTC](https://discourse.nodered.org/t/node-red-query-for-an-ip-cam-token/72552 "2022-12-21T20:14:38Z")

</div>

Hi, can you request a token from an IP cam with Node Red and http request? Specifically, it is about a Reolink Cam and I would like to use the API that Reolink provides to switch the push notification on and off. To d…

---

## [Sending data to InfluxDB](https://discourse.nodered.org/t/sending-data-to-influxdb/72505)

<div class="topic-metadata">

**Author:** [@Weinsberg](https://discourse.nodered.org/u/Weinsberg)\
**Replies:** 2\
**Last updated:** [21 December 2022 19:39 UTC](https://discourse.nodered.org/t/sending-data-to-influxdb/72505 "2022-12-21T19:39:13Z")

</div>

Hey there, I'm not getting forward on my project, here shortly: sensors geathering data and send via LoRaWAN to the house raspberry pi get these data from serial port and stores it in influxDB-1.x grafana should visual…

---

## [ECharts: set up/save input array](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335)

<div class="topic-metadata">

**Author:** [@interscope101](https://discourse.nodered.org/u/interscope101)\
**Replies:** 31\
**Last updated:** [21 December 2022 17:54 UTC](https://discourse.nodered.org/t/echarts-set-up-save-input-array/71335 "2022-12-21T17:54:07Z")

</div>

Hi there! Trying to plot two daily profit data points ('day" and "total") using line echarts. Everything is prepped, just stuck on the task of setting up and saving the array every 24 hours. Here is the function gen…

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

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