# General

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

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

**Page:** 568

---

## [MSSQL query sum value display in ui\_text](https://discourse.nodered.org/t/mssql-query-sum-value-display-in-ui-text/44432)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 3\
**Last updated:** [22 April 2021 17:57 UTC](https://discourse.nodered.org/t/mssql-query-sum-value-display-in-ui-text/44432 "2021-04-22T17:57:10Z")

</div>

Need help to display only numeric value. I'm getting value with brackets/special characters \[{" ": value }\]. Can anyone please help. flow given below: \[{"id":"ff3a0683.417658","type":"MSSQL","z":"6741e784.e28a18",…

---

## [Node to show the actual status](https://discourse.nodered.org/t/node-to-show-the-actual-status/44412)

<div class="topic-metadata">

**Author:** [@melrose](https://discourse.nodered.org/u/melrose)\
**Replies:** 6\
**Last updated:** [22 April 2021 17:51 UTC](https://discourse.nodered.org/t/node-to-show-the-actual-status/44412 "2021-04-22T17:51:15Z")

</div>

hello im using a unconnected outnode to display me the value of the last message. in newer version of node red this is not working. Debug node is puting it in a window somewhere else, i want it directly in the editor. ho…

---

## [Crediting authors after forking a module](https://discourse.nodered.org/t/crediting-authors-after-forking-a-module/44546)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 9\
**Last updated:** [22 April 2021 17:32 UTC](https://discourse.nodered.org/t/crediting-authors-after-forking-a-module/44546 "2021-04-22T17:32:07Z")

</div>

I have forked the node-red-node-pi-gpio module to port it to the Nvidia Jetson Nano. While I've made some extensive changes to the logic, it wouldn't have been possible if I had to start from scratch. What is the proper…

---

## [Mysql dynamic query from key/value object](https://discourse.nodered.org/t/mysql-dynamic-query-from-key-value-object/44559)

<div class="topic-metadata">

**Author:** [@danipenn](https://discourse.nodered.org/u/danipenn)\
**Replies:** 2\
**Last updated:** [22 April 2021 17:14 UTC](https://discourse.nodered.org/t/mysql-dynamic-query-from-key-value-object/44559 "2021-04-22T17:14:00Z")

</div>

Hi to all, i'm newbie on node red and JS and i'm writing to you for some help with node red and mysql query. it's 2 days i'm googling but i can't find solution. My problem is to built query string dynamically from many…

---

## [\[solved\] Deploying - function node change the status (even the condition ist not true)](https://discourse.nodered.org/t/solved-deploying-function-node-change-the-status-even-the-condition-ist-not-true/44534)

<div class="topic-metadata">

**Author:** [@steinerma](https://discourse.nodered.org/u/steinerma)\
**Replies:** 2\
**Last updated:** [22 April 2021 14:45 UTC](https://discourse.nodered.org/t/solved-deploying-function-node-change-the-status-even-the-condition-ist-not-true/44534 "2021-04-22T14:45:29Z")

</div>

hi, every time I redeploy (full), this "function node" sends me a "true" for a short time, even if the condition is not true. How can I prevent this? \[{"id":"ec8d8697.cb8028","type":"function","z":"df764457.a3c8e8","nam…

---

## [Cant send ESP32 data to Cloudant](https://discourse.nodered.org/t/cant-send-esp32-data-to-cloudant/44549)

<div class="topic-metadata">

**Author:** [@BrianMcDonagh](https://discourse.nodered.org/u/BrianMcDonagh)\
**Replies:** 0\
**Last updated:** [22 April 2021 14:20 UTC](https://discourse.nodered.org/t/cant-send-esp32-data-to-cloudant/44549 "2021-04-22T14:20:03Z")

</div>

Hi, I am trying to connect an ESP32 to the IBM Watson IoT platform and then get the information that is published to be saved in Cloudant by using the Node Red Watson IoT node connected to a Cloudant node. I can get the…

---

## [Simple chart export to html instead of chart node](https://discourse.nodered.org/t/simple-chart-export-to-html-instead-of-chart-node/44541)

<div class="topic-metadata">

**Author:** [@nerevar](https://discourse.nodered.org/u/nerevar)\
**Replies:** 0\
**Last updated:** [22 April 2021 12:55 UTC](https://discourse.nodered.org/t/simple-chart-export-to-html-instead-of-chart-node/44541 "2021-04-22T12:55:06Z")

</div>

Hello all, I am working for a couple of months now on a platform for status reporting using RevolutionPi (raspberry based). I've set up node-red + mdashboard for charts. As I am new to JS and HTML, most of it came from…

---

## [Use Wildcard for multiple state attributes in trigger-state node](https://discourse.nodered.org/t/use-wildcard-for-multiple-state-attributes-in-trigger-state-node/44540)

<div class="topic-metadata">

**Author:** [@peetipablo](https://discourse.nodered.org/u/peetipablo)\
**Replies:** 0\
**Last updated:** [22 April 2021 12:37 UTC](https://discourse.nodered.org/t/use-wildcard-for-multiple-state-attributes-in-trigger-state-node/44540 "2021-04-22T12:37:31Z")

</div>

I have a flow that, between the hours of 6PM and 12AM, will check forecast precipitation conditions and alert me if any hour is within 'rainy' or 'snowy' conditions. I use this as a reminder to make sure our patio furni…

---

## [Node-red-contrib-msg-queue - Only storing not forwarding w/ active connection](https://discourse.nodered.org/t/node-red-contrib-msg-queue-only-storing-not-forwarding-w-active-connection/44274)

<div class="topic-metadata">

**Author:** [@jakonnode](https://discourse.nodered.org/u/jakonnode)\
**Replies:** 20\
**Last updated:** [22 April 2021 12:15 UTC](https://discourse.nodered.org/t/node-red-contrib-msg-queue-only-storing-not-forwarding-w-active-connection/44274 "2021-04-22T12:15:39Z")

</div>

I am using node-red-contrib-msg-queue (queue) node for 'store and forward' type of usecase to MQTT. Message gets stored (verified in the queue table in SQLite) but never flows out to the outbound node even though the MQ…

---

## [Generate CSV files](https://discourse.nodered.org/t/generate-csv-files/44531)

<div class="topic-metadata">

**Author:** [@TimTist](https://discourse.nodered.org/u/TimTist)\
**Replies:** 3\
**Last updated:** [22 April 2021 10:47 UTC](https://discourse.nodered.org/t/generate-csv-files/44531 "2021-04-22T10:47:00Z")

</div>

I run into a problem generating a CSV file, maybe someone can help me. The TTN Uplink Node gets the data, the Change Node generates the array and the Edit CSV Node generates a comma separated CSV file which is saved …

---

## [Cant install sqlite node in node-red addon (Home Assistant)](https://discourse.nodered.org/t/cant-install-sqlite-node-in-node-red-addon-home-assistant/44525)

<div class="topic-metadata">

**Author:** [@vks007](https://discourse.nodered.org/u/vks007)\
**Replies:** 2\
**Last updated:** [22 April 2021 09:42 UTC](https://discourse.nodered.org/t/cant-install-sqlite-node-in-node-red-addon-home-assistant/44525 "2021-04-22T09:42:53Z")

</div>

I am trying to install sqlite node in node-red and I am unable to do so. I get the following error log. I have reviewed some other posts speaking of the same issue but non of them seems to be on the node red add on which…

---

## [Help with a water sensor flow](https://discourse.nodered.org/t/help-with-a-water-sensor-flow/44499)

<div class="topic-metadata">

**Author:** [@leftymuller](https://discourse.nodered.org/u/leftymuller)\
**Replies:** 5\
**Last updated:** [22 April 2021 09:31 UTC](https://discourse.nodered.org/t/help-with-a-water-sensor-flow/44499 "2021-04-22T09:31:03Z")

</div>

Hi all, Could I ask for some advice on my current project flow.. Any help appreciated This flow gets pulses from a water flow sensor and sends a pulse every litre pumped into a tank from a bore and displays them. The …

---

## [Can I access context from my html file?](https://discourse.nodered.org/t/can-i-access-context-from-my-html-file/44530)

<div class="topic-metadata">

**Author:** [@Dian](https://discourse.nodered.org/u/Dian)\
**Replies:** 0\
**Last updated:** [22 April 2021 09:09 UTC](https://discourse.nodered.org/t/can-i-access-context-from-my-html-file/44530 "2021-04-22T09:09:01Z")

</div>

Hello, so here is some context (pun intended) : I'm using in my flow different read nodes, depending on the protocol used (s7, OPCUA, etc), connected to a plc, and I'm sending the payload {variableName1: data, variableNa…

---

## [\[solved\] Function node - no repeat signal](https://discourse.nodered.org/t/solved-function-node-no-repeat-signal/44522)

<div class="topic-metadata">

**Author:** [@steinerma](https://discourse.nodered.org/u/steinerma)\
**Replies:** 2\
**Last updated:** [22 April 2021 07:52 UTC](https://discourse.nodered.org/t/solved-function-node-no-repeat-signal/44522 "2021-04-22T07:52:50Z")

</div>

Hi, from "link in", I get the result of a cyclic query (every 5 seconds). This result I convert from on/off to true/false. However, the output of the "function node" should only send the value at the output when the sta…

---

## [Unable to connect to MySQL](https://discourse.nodered.org/t/unable-to-connect-to-mysql/44519)

<div class="topic-metadata">

**Author:** [@Gabriel1](https://discourse.nodered.org/u/Gabriel1)\
**Replies:** 1\
**Last updated:** [22 April 2021 06:01 UTC](https://discourse.nodered.org/t/unable-to-connect-to-mysql/44519 "2021-04-22T06:01:16Z")

</div>

Hello. Im working on a flow to pull data from phpMyadmin but recently after trying to use electron node red to package my file into an exe, mysql node refuses to connect and keeps giving me this error. I have looked thro…

---

## [Suggestions, please, for Alexa skill that triggers automation based on Yes/No response](https://discourse.nodered.org/t/suggestions-please-for-alexa-skill-that-triggers-automation-based-on-yes-no-response/14106)

<div class="topic-metadata">

**Author:** [@OctavioMasomenos](https://discourse.nodered.org/u/OctavioMasomenos)\
**Replies:** 5\
**Last updated:** [22 April 2021 01:03 UTC](https://discourse.nodered.org/t/suggestions-please-for-alexa-skill-that-triggers-automation-based-on-yes-no-response/14106 "2021-04-22T01:03:19Z")

</div>

Since it doesn’t exist, I’m going to try to write an Alexa skill that will ask a question, wait for a yes or no response, then take action accordingly. The thing is, I want it to be modular so it can be used in any numbe…

---

## [Send a photo to Telegram](https://discourse.nodered.org/t/send-a-photo-to-telegram/5528)

<div class="topic-metadata">

**Author:** [@talud08](https://discourse.nodered.org/u/talud08)\
**Replies:** 19\
**Last updated:** [21 April 2021 18:02 UTC](https://discourse.nodered.org/t/send-a-photo-to-telegram/5528 "2021-04-21T18:02:00Z")

</div>

I need some help in order to send a photo taken with the pi camera to Telegram. I am using "node-red-contrib-telegrambot-home" and these are the flow and nodes: -- With this flow the picture is taken and store…

---

## [Tips for putting node-red in a good light for a presentation](https://discourse.nodered.org/t/tips-for-putting-node-red-in-a-good-light-for-a-presentation/44470)

<div class="topic-metadata">

**Author:** [@crydrk](https://discourse.nodered.org/u/crydrk)\
**Replies:** 3\
**Last updated:** [21 April 2021 17:32 UTC](https://discourse.nodered.org/t/tips-for-putting-node-red-in-a-good-light-for-a-presentation/44470 "2021-04-21T17:32:18Z")

</div>

Hello, I've been using node-red casually for a couple years. I'm primarily a technical artist and don't go super deep on the tech side but make my way around. I mostly just send udp between Arduino, RPi and Unity and use…

---

## [How can I avoid getting messages when there are no people in the pictures](https://discourse.nodered.org/t/how-can-i-avoid-getting-messages-when-there-are-no-people-in-the-pictures/44440)

<div class="topic-metadata">

**Author:** [@tpbillund](https://discourse.nodered.org/u/tpbillund)\
**Replies:** 4\
**Last updated:** [21 April 2021 15:47 UTC](https://discourse.nodered.org/t/how-can-i-avoid-getting-messages-when-there-are-no-people-in-the-pictures/44440 "2021-04-21T15:47:54Z")

</div>

Some time ago I set up a "MotionEye" where I run some "Motion Detection" on the video part. I then run a "Motion Notification" by two scripts. And then throw this information into my HA, where I have access to "Deepsta…

---

## [Cannot find module './lib/agent'](https://discourse.nodered.org/t/cannot-find-module-lib-agent/44438)

<div class="topic-metadata">

**Author:** [@PA.YOT-V](https://discourse.nodered.org/u/PA.YOT-V)\
**Replies:** 3\
**Last updated:** [21 April 2021 06:00 UTC](https://discourse.nodered.org/t/cannot-find-module-lib-agent/44438 "2021-04-21T06:00:19Z")

</div>

Error Show: Blockquote 20 Apr 11:33:20 - \[warn\] ------------------------------------------ 20 Apr 11:33:20 - \[error\] Error: Install failed 20 Apr 11:44:30 - \[info\] Installing module: node-red-contrib-modbus, version…

---

## [Notification from node red](https://discourse.nodered.org/t/notification-from-node-red/44057)

<div class="topic-metadata">

**Author:** [@Alex95](https://discourse.nodered.org/u/Alex95)\
**Replies:** 55\
**Last updated:** [20 April 2021 20:32 UTC](https://discourse.nodered.org/t/notification-from-node-red/44057 "2021-04-20T20:32:34Z")

</div>

Hello everyone. Before i tell you my problem i will explain you what i have done so far. So, i have 2 Arduino which communicate via LoRa (because i have added 2 Dragino shields on Arduino). Arduino send the following dat…

---

## [Data to SQLite help](https://discourse.nodered.org/t/data-to-sqlite-help/44414)

<div class="topic-metadata">

**Author:** [@biros](https://discourse.nodered.org/u/biros)\
**Replies:** 12\
**Last updated:** [20 April 2021 17:44 UTC](https://discourse.nodered.org/t/data-to-sqlite-help/44414 "2021-04-20T17:44:18Z")

</div>

Hello, I am having a hard time inserting a few values into a db. The flow looks like this; \[{"id":"1f014414.ca877c","type":"sqlite","z":"f10130b.539efd","mydb":"dd149518.c13258","sqlquery":"msg.topic","sql":"","nam…

---

## [HTTP Request Fails](https://discourse.nodered.org/t/http-request-fails/44460)

<div class="topic-metadata">

**Author:** [@Randy](https://discourse.nodered.org/u/Randy)\
**Replies:** 11\
**Last updated:** [20 April 2021 17:20 UTC](https://discourse.nodered.org/t/http-request-fails/44460 "2021-04-20T17:20:51Z")

</div>

I can use this url in a browser and it will make my PTZ camera change to the preset number http://192.168.1.110/axis-cgi/com/ptz.cgi?gotoserverpresetno=1 However using a HTTP Request Node with POST, the camera does not…

---

## [How to extract characters using Javascript in a function?](https://discourse.nodered.org/t/how-to-extract-characters-using-javascript-in-a-function/44435)

<div class="topic-metadata">

**Author:** [@MercierFab](https://discourse.nodered.org/u/MercierFab)\
**Replies:** 3\
**Last updated:** [20 April 2021 16:55 UTC](https://discourse.nodered.org/t/how-to-extract-characters-using-javascript-in-a-function/44435 "2021-04-20T16:55:46Z")

</div>

Hello, I need to extract 2 characters from a payload (string) using substr(x,y) in a function node and it doesn't work. ex : var temperature = payload.substr(2,4). The function doesn't exist. Should I install a package o…

---

## [Not able to login with LDAP user](https://discourse.nodered.org/t/not-able-to-login-with-ldap-user/44400)

<div class="topic-metadata">

**Author:** [@codecracker2020](https://discourse.nodered.org/u/codecracker2020)\
**Replies:** 1\
**Last updated:** [20 April 2021 14:04 UTC](https://discourse.nodered.org/t/not-able-to-login-with-ldap-user/44400 "2021-04-20T14:04:52Z")

</div>

Hi Team, I am not able to login with LDAP user. I set the adminAuth with "node-red-contrib-ldap-auth", "node-red-auth-contrib-ldap". I am getting the below error: {"error":"invalid\_grant","error\_description":"Invalid r…

---

## [Node-red app deployment to live server](https://discourse.nodered.org/t/node-red-app-deployment-to-live-server/44459)

<div class="topic-metadata">

**Author:** [@Syedabd](https://discourse.nodered.org/u/Syedabd)\
**Replies:** 3\
**Last updated:** [20 April 2021 12:56 UTC](https://discourse.nodered.org/t/node-red-app-deployment-to-live-server/44459 "2021-04-20T12:56:48Z")

</div>

Hi, Can anyone help me out? Which is the file in a node-red application that needs to be deployed to the server after I run the command grunt build/npm run build How to deploy node-red application to the live server ? …

---

## [Mqtt broker - add a new one via ui?](https://discourse.nodered.org/t/mqtt-broker-add-a-new-one-via-ui/44391)

<div class="topic-metadata">

**Author:** [@alexander77](https://discourse.nodered.org/u/alexander77)\
**Replies:** 2\
**Last updated:** [20 April 2021 11:18 UTC](https://discourse.nodered.org/t/mqtt-broker-add-a-new-one-via-ui/44391 "2021-04-20T11:18:21Z")

</div>

Is it possible to add the mqtt connect infos via a user interface page instead of the setup in the flow? I do similar things with tcp-connections, where msg.port and msg.ip are good friends of mine.

---

## [How do I get Yesterdays day](https://discourse.nodered.org/t/how-do-i-get-yesterdays-day/44451)

<div class="topic-metadata">

**Author:** [@martinschki](https://discourse.nodered.org/u/martinschki)\
**Replies:** 2\
**Last updated:** [20 April 2021 10:14 UTC](https://discourse.nodered.org/t/how-do-i-get-yesterdays-day/44451 "2021-04-20T10:14:59Z")

</div>

Hello! I have, at least for me, an interesting problem: Every day I need to save a value from the day before into a csv file. Therefore I create a file based on month/year and create a line for each day and the respec…

---

## [MQTT stuck on Yellow Connecting](https://discourse.nodered.org/t/mqtt-stuck-on-yellow-connecting/44450)

<div class="topic-metadata">

**Author:** [@bmavina](https://discourse.nodered.org/u/bmavina)\
**Replies:** 3\
**Last updated:** [20 April 2021 09:56 UTC](https://discourse.nodered.org/t/mqtt-stuck-on-yellow-connecting/44450 "2021-04-20T09:56:59Z")

</div>

I'v created a MQTT node and which i have linked with influx DB node. My mqtt node is supposed to be connect with my device on the TTN "co-sensor1". I have followed all the steps to set up the mqtt node that TTN has poste…

---

## [MySQL fails after an hour or so](https://discourse.nodered.org/t/mysql-fails-after-an-hour-or-so/43225)

<div class="topic-metadata">

**Author:** [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Replies:** 17\
**Last updated:** [20 April 2021 08:25 UTC](https://discourse.nodered.org/t/mysql-fails-after-an-hour-or-so/43225 "2021-04-20T08:25:04Z")

</div>

I have a flow that does a dB query to obtain stored data from my weather stations. It does a SELECT using "node100" or "node101" to obtain the appropriate data. It works for some hours and then hangs up with this error…

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

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