# General

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

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

**Page:** 756

---

## [Mongodb3 sort command to find maximum value](https://discourse.nodered.org/t/mongodb3-sort-command-to-find-maximum-value/25936)

<div class="topic-metadata">

**Author:** [@divyansh](https://discourse.nodered.org/u/divyansh)\
**Replies:** 0\
**Last updated:** [2 May 2020 16:14 UTC](https://discourse.nodered.org/t/mongodb3-sort-command-to-find-maximum-value/25936 "2020-05-02T16:14:22Z")

</div>

Hi, I am unable to understand, the functioning of mongodb3 package. I am trying to get max value , using following. msg.operation="findOne"; msg.sort={\_id:-1}; msg.limit=1; return msg; However this command runs perfe…

---

## [Save data in local Mongodb](https://discourse.nodered.org/t/save-data-in-local-mongodb/25919)

<div class="topic-metadata">

**Author:** [@MoMo](https://discourse.nodered.org/u/MoMo)\
**Replies:** 0\
**Last updated:** [2 May 2020 12:13 UTC](https://discourse.nodered.org/t/save-data-in-local-mongodb/25919 "2020-05-02T12:13:16Z")

</div>

Hi everybody, I'm struggeling with mongodb. How can i save Data in my mongodb on my PC? I installed the mongodb2 at node-red and also locally on my PC. When i deploy and push the inject node, there is a debugging outpu…

---

## ["grep" words from /var/log/messages](https://discourse.nodered.org/t/grep-words-from-var-log-messages/25912)

<div class="topic-metadata">

**Author:** [@menno](https://discourse.nodered.org/u/menno)\
**Replies:** 8\
**Last updated:** [2 May 2020 11:30 UTC](https://discourse.nodered.org/t/grep-words-from-var-log-messages/25912 "2020-05-02T11:30:49Z")

</div>

Hi all i am busy to get some special data from my /var/log/messages file this is the line that i am interested in: May 2 10:52:23 mw-pi-star root M: 2020-05-02 08:52:23.188 Linked to PARROT i just want to have this …

---

## [Setting font color for a value](https://discourse.nodered.org/t/setting-font-color-for-a-value/25862)

<div class="topic-metadata">

**Author:** [@AndrewZ](https://discourse.nodered.org/u/AndrewZ)\
**Replies:** 4\
**Last updated:** [2 May 2020 10:07 UTC](https://discourse.nodered.org/t/setting-font-color-for-a-value/25862 "2020-05-02T10:07:00Z")

</div>

I've seen a number of examples on how to set the font color (or an icon) for the whole message using msg.color but I'm looking for the right way to do the same basing on the value within the message. In my case the mess…

---

## [MySQL to Telegram](https://discourse.nodered.org/t/mysql-to-telegram/25913)

<div class="topic-metadata">

**Author:** [@Hunter](https://discourse.nodered.org/u/Hunter)\
**Replies:** 1\
**Last updated:** [2 May 2020 09:13 UTC](https://discourse.nodered.org/t/mysql-to-telegram/25913 "2020-05-02T09:13:26Z")

</div>

Hi all, I'm using the node-red-node-mysql to fetch data from a database. This part is working. I'm getting this data : msg.payload : array\[1\] array\[1\] 0: object zoektekst: "Schoorveld Maasbree 233291" Now I would…

---

## [Using the exec node to kill and restart a process](https://discourse.nodered.org/t/using-the-exec-node-to-kill-and-restart-a-process/25893)

<div class="topic-metadata">

**Author:** [@wdmtech](https://discourse.nodered.org/u/wdmtech)\
**Replies:** 4\
**Last updated:** [2 May 2020 07:42 UTC](https://discourse.nodered.org/t/using-the-exec-node-to-kill-and-restart-a-process/25893 "2020-05-02T07:42:25Z")

</div>

Hey, I've got a few devices from Pimoroni, for example This comes with some nice examples, for instance, to scroll text across the HAT. I'm looking for a way to kill the text scrolling process (python3) and start a n…

---

## [Node-red-contrib-life](https://discourse.nodered.org/t/node-red-contrib-life/24702)

<div class="topic-metadata">

**Author:** [@grumpazoid](https://discourse.nodered.org/u/grumpazoid)\
**Replies:** 7\
**Last updated:** [2 May 2020 01:34 UTC](https://discourse.nodered.org/t/node-red-contrib-life/24702 "2020-05-02T01:34:54Z")

</div>

I just wanted to ask if anyone has experience with this life360 node. There is no documentation provided. Just wanted to check it is firstly safe and if I could pass location data onto worldmap.

---

## [Help needed to install node-red-contrib-db2-for-i](https://discourse.nodered.org/t/help-needed-to-install-node-red-contrib-db2-for-i/25877)

<div class="topic-metadata">

**Author:** [@sara88m](https://discourse.nodered.org/u/sara88m)\
**Replies:** 7\
**Last updated:** [2 May 2020 01:19 UTC](https://discourse.nodered.org/t/help-needed-to-install-node-red-contrib-db2-for-i/25877 "2020-05-02T01:19:32Z")

</div>

Hi everyone. I need to install node-red-contrib-db2-for-i on my node red, but I got error. I use win7-64x. Then I tried with node-red-contrib-db2-fixed, and I could installed it. Want to know , are these two nodes diffe…

---

## [Mysql etimedout](https://discourse.nodered.org/t/mysql-etimedout/25703)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 17\
**Last updated:** [1 May 2020 21:22 UTC](https://discourse.nodered.org/t/mysql-etimedout/25703 "2020-05-01T21:22:09Z")

</div>

After doing a lot of mysql locally i am trying something from one to another server now It works but after about 8 seconds i get etimedout When i trigger the node again i get a correct output then 8 sec later again a e…

---

## [Solving mathematical functions made from dashboard inputs](https://discourse.nodered.org/t/solving-mathematical-functions-made-from-dashboard-inputs/23812)

<div class="topic-metadata">

**Author:** [@lalo](https://discourse.nodered.org/u/lalo)\
**Replies:** 54\
**Last updated:** [1 May 2020 20:21 UTC](https://discourse.nodered.org/t/solving-mathematical-functions-made-from-dashboard-inputs/23812 "2020-05-01T20:21:16Z")

</div>

hi i'm working on a dropdown with options so basically i want to write some equations and save it in a database to use and then recover it on a dropdown like new options and when i choose for example equation 1 send this…

---

## [NodeRED on SSL https://](https://discourse.nodered.org/t/nodered-on-ssl-https/25483)

<div class="topic-metadata">

**Author:** [@jithinsisaac](https://discourse.nodered.org/u/jithinsisaac)\
**Replies:** 3\
**Last updated:** [1 May 2020 18:51 UTC](https://discourse.nodered.org/t/nodered-on-ssl-https/25483 "2020-05-01T18:51:33Z")

</div>

Hey.. I have my Node-Red setup on a VPS by Digital Ocean. I can access it via http:// IP:1880 I am logging in via admin and password, that i have already generated. I bought a domain a few days back. (Eg. example. com…

---

## [Use "flow." payload in Button node](https://discourse.nodered.org/t/use-flow-payload-in-button-node/25867)

<div class="topic-metadata">

**Author:** [@notnice](https://discourse.nodered.org/u/notnice)\
**Replies:** 6\
**Last updated:** [1 May 2020 17:28 UTC](https://discourse.nodered.org/t/use-flow-payload-in-button-node/25867 "2020-05-01T17:28:37Z")

</div>

I want to set a flow variable via a button when its pressed. Can't find any docs on the format for this button payload option and the usual format I'd use in a function node as below (and several variants I have tried) f…

---

## [Issue authenticating Google Calendar Node](https://discourse.nodered.org/t/issue-authenticating-google-calendar-node/25872)

<div class="topic-metadata">

**Author:** [@phreaq](https://discourse.nodered.org/u/phreaq)\
**Replies:** 0\
**Last updated:** [1 May 2020 15:25 UTC](https://discourse.nodered.org/t/issue-authenticating-google-calendar-node/25872 "2020-05-01T15:25:07Z")

</div>

I am trying to set up the Google Calendar Node, and I am having an issue entering in my credentials. I have created a Project, and turned on the Google+ and Google Calendar APIs, as well as added a redirect URL. I ente…

---

## [\[off-topic\] dashboard as wallpanel on TV via IPTV?](https://discourse.nodered.org/t/off-topic-dashboard-as-wallpanel-on-tv-via-iptv/25704)

<div class="topic-metadata">

**Author:** [@hominidae](https://discourse.nodered.org/u/hominidae)\
**Replies:** 9\
**Last updated:** [1 May 2020 13:43 UTC](https://discourse.nodered.org/t/off-topic-dashboard-as-wallpanel-on-tv-via-iptv/25704 "2020-05-01T13:43:40Z")

</div>

HI folks, my apologies upfront, as I think this is quite a bit off-topic for node-red in genaral or its dashboard cateory. But my google-fu lost me and I am hoping some of you might have an idea on how this can be done…

---

## [Google home support other then NORA?](https://discourse.nodered.org/t/google-home-support-other-then-nora/25866)

<div class="topic-metadata">

**Author:** [@realjax](https://discourse.nodered.org/u/realjax)\
**Replies:** 0\
**Last updated:** [1 May 2020 12:53 UTC](https://discourse.nodered.org/t/google-home-support-other-then-nora/25866 "2020-05-01T12:53:53Z")

</div>

Hi I have been using node-red-contrib-nora for my interactions with Google Home. I love the simplicity of this node, but the devices it supports are only a fraction of the devices currently supported and documented by …

---

## [Change field name](https://discourse.nodered.org/t/change-field-name/25858)

<div class="topic-metadata">

**Author:** [@andreas58](https://discourse.nodered.org/u/andreas58)\
**Replies:** 2\
**Last updated:** [1 May 2020 12:19 UTC](https://discourse.nodered.org/t/change-field-name/25858 "2020-05-01T12:19:53Z")

</div>

How can I turn a field name into a payload? I have a LoraWan node that sends GPS coordinates via TTN to Cayenne. I want to use the same payload also in Node-red but to do so I need to change the field names latitude and…

---

## [Problem add Object to Array](https://discourse.nodered.org/t/problem-add-object-to-array/25763)

<div class="topic-metadata">

**Author:** [@grooveagent](https://discourse.nodered.org/u/grooveagent)\
**Replies:** 5\
**Last updated:** [1 May 2020 11:53 UTC](https://discourse.nodered.org/t/problem-add-object-to-array/25763 "2020-05-01T11:53:49Z")

</div>

Hi together, I'm stuck with a beginner Problem to push an Object to an Array of Object... What I want to do: I have a dashboard where the user can put in different values which are stored in several object-properties.…

---

## [Convert all values in array](https://discourse.nodered.org/t/convert-all-values-in-array/25853)

<div class="topic-metadata">

**Author:** [@AndrewZ](https://discourse.nodered.org/u/AndrewZ)\
**Replies:** 2\
**Last updated:** [1 May 2020 09:48 UTC](https://discourse.nodered.org/t/convert-all-values-in-array/25853 "2020-05-01T09:48:42Z")

</div>

This is one of my first exercises with Node-RED, so please be kind :wink: I'm creating a simple dashboard to control my Modbus devices. Currently I can see the status of a few inputs and control the state of a few outpu…

---

## [Calculate rain precipitation from URL with columns](https://discourse.nodered.org/t/calculate-rain-precipitation-from-url-with-columns/25849)

<div class="topic-metadata">

**Author:** [@HaVi](https://discourse.nodered.org/u/HaVi)\
**Replies:** 6\
**Last updated:** [1 May 2020 08:24 UTC](https://discourse.nodered.org/t/calculate-rain-precipitation-from-url-with-columns/25849 "2020-05-01T08:24:11Z")

</div>

Via the URL https://gpsgadget.buienradar.nl/data/raintext/?lat=52.37&lon=4.89 I can get the expected rainfall for the next two hours for a GPS location. This is shown in two columns, the amount of precipitation on the le…

---

## [Node-RED User Directory](https://discourse.nodered.org/t/node-red-user-directory/25454)

<div class="topic-metadata">

**Author:** [@DizzyLurker](https://discourse.nodered.org/u/DizzyLurker)\
**Replies:** 2\
**Last updated:** [1 May 2020 06:04 UTC](https://discourse.nodered.org/t/node-red-user-directory/25454 "2020-05-01T06:04:49Z")

</div>

Hey, I was hopeful I could move the working directory of Node-RED from the default location ( C:\\Users\\UserName.node-red ) to my Drop Box syncing directory. The reason I want to do this is twice now I have changed lapto…

---

## [Node.error only sends msg.payload](https://discourse.nodered.org/t/node-error-only-sends-msg-payload/25845)

<div class="topic-metadata">

**Author:** [@svj](https://discourse.nodered.org/u/svj)\
**Replies:** 2\
**Last updated:** [1 May 2020 05:09 UTC](https://discourse.nodered.org/t/node-error-only-sends-msg-payload/25845 "2020-05-01T05:09:44Z")

</div>

Hi All, I'm having issues getting the node.error function to return the complete message in the catch node. I'm using node.error("error test", msg); in a function node. The catch node only returns msg.payload. What…

---

## [Assign key to variable](https://discourse.nodered.org/t/assign-key-to-variable/25837)

<div class="topic-metadata">

**Author:** [@chrisgla](https://discourse.nodered.org/u/chrisgla)\
**Replies:** 9\
**Last updated:** [1 May 2020 01:37 UTC](https://discourse.nodered.org/t/assign-key-to-variable/25837 "2020-05-01T01:37:11Z")

</div>

Struggling to get the format correct for this:- var VehTemp = "msg.payload.climate\_state.outside\_temp" || 99; Have tried separators, moustache's and probably grown a beard while trying! Thanks! \[{"id":"2f4b71c.592088…

---

## [MQTT set via flow](https://discourse.nodered.org/t/mqtt-set-via-flow/25836)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 3\
**Last updated:** [30 April 2020 21:56 UTC](https://discourse.nodered.org/t/mqtt-set-via-flow/25836 "2020-04-30T21:56:55Z")

</div>

Are there a way of setting the MQTT via a flow?

---

## [More help with BigTimer](https://discourse.nodered.org/t/more-help-with-bigtimer/25789)

<div class="topic-metadata">

**Author:** [@ajaymccollum](https://discourse.nodered.org/u/ajaymccollum)\
**Replies:** 2\
**Last updated:** [30 April 2020 21:29 UTC](https://discourse.nodered.org/t/more-help-with-bigtimer/25789 "2020-04-30T21:29:14Z")

</div>

The BigTimer node seems like it'd do the trick I'm trying to do, so that's why I'm asking under the context of it. I'm trying to get it send a message just once a month, every month. I've been playing with some of the se…

---

## [usb-Serial-port:how to send a message like Pyserial?](https://discourse.nodered.org/t/usb-serial-port-how-to-send-a-message-like-pyserial/25794)

<div class="topic-metadata">

**Author:** [@canoe](https://discourse.nodered.org/u/canoe)\
**Replies:** 5\
**Last updated:** [30 April 2020 19:41 UTC](https://discourse.nodered.org/t/usb-serial-port-how-to-send-a-message-like-pyserial/25794 "2020-04-30T19:41:20Z")

</div>

I am using a usb-serial with /dev/ttyUSB0, in RaspberryPi, I can send/receive messages as following python code, #python-start command = b'\\x01\\x04\\x00\\x00\\x00\\x02\\x71\\xcb' with serial.Serial("/dev/ttyUSB0", baudrate=…

---

## [How to combine sensor data and add them to influxdb](https://discourse.nodered.org/t/how-to-combine-sensor-data-and-add-them-to-influxdb/25828)

<div class="topic-metadata">

**Author:** [@MichaelM](https://discourse.nodered.org/u/MichaelM)\
**Replies:** 2\
**Last updated:** [30 April 2020 17:38 UTC](https://discourse.nodered.org/t/how-to-combine-sensor-data-and-add-them-to-influxdb/25828 "2020-04-30T17:38:50Z")

</div>

Hi, I've spend now a lot of time with google and youtube, but still I've found no solution for a potenitally simple question: I'm sendind from an ESP32 MQTT messages. All start with ESP32/... (ESP32/temperature, ESP32/…

---

## [Uibuilder get specific value from json](https://discourse.nodered.org/t/uibuilder-get-specific-value-from-json/25735)

<div class="topic-metadata">

**Author:** [@pawel256](https://discourse.nodered.org/u/pawel256)\
**Replies:** 1\
**Last updated:** [30 April 2020 17:14 UTC](https://discourse.nodered.org/t/uibuilder-get-specific-value-from-json/25735 "2020-04-30T17:14:37Z")

</div>

How to get value from uibuilder json. I try MSG: {{msgRecvd.payload.item1}} but it doesn't work \[{"id":"b736e61c.c8cc","type":"tab","label":"Flow 6","disabled":false,"info":""},{"id":"2f27ec13.9dc35c","type":"uibuilder"…

---

## [Creating project on GitLab](https://discourse.nodered.org/t/creating-project-on-gitlab/25765)

<div class="topic-metadata">

**Author:** [@JustSeen](https://discourse.nodered.org/u/JustSeen)\
**Replies:** 5\
**Last updated:** [30 April 2020 16:42 UTC](https://discourse.nodered.org/t/creating-project-on-gitlab/25765 "2020-04-30T16:42:20Z")

</div>

Hi, I need your help today because i have to commit my node red flow on gitlab. But i don't understand how i can do it. If someone could help me. Thanks you.

---

## [Moving a set of flows to a other machine](https://discourse.nodered.org/t/moving-a-set-of-flows-to-a-other-machine/25818)

<div class="topic-metadata">

**Author:** [@maxmueller50](https://discourse.nodered.org/u/maxmueller50)\
**Replies:** 2\
**Last updated:** [30 April 2020 15:47 UTC](https://discourse.nodered.org/t/moving-a-set-of-flows-to-a-other-machine/25818 "2020-04-30T15:47:32Z")

</div>

Hi I have running a RPi 3+ running with N-R now over 3 years for my garden irrigation system. Last year I began to build up a weather-station (arduino and a RPi 4 as data server) By the installation of msql/MariaDb I …

---

## [Link with my Website](https://discourse.nodered.org/t/link-with-my-website/25823)

<div class="topic-metadata">

**Author:** [@EstebanGV](https://discourse.nodered.org/u/EstebanGV)\
**Replies:** 0\
**Last updated:** [30 April 2020 15:42 UTC](https://discourse.nodered.org/t/link-with-my-website/25823 "2020-04-30T15:42:55Z")

</div>

Hello, I hope if someone can help me to find info. to link my data from node-red to my website. I have a url to make a test and send data. I can connect to my web and get info from there with http request but i dont k…

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

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