# Combine several messages from MQTT into one request to DataBase

**URL:** <https://discourse.nodered.org/t/combine-several-messages-from-mqtt-into-one-request-to-database/27915>\
**Category:** General\
**Created:** [6 June 2020 20:10 UTC](https://discourse.nodered.org/t/combine-several-messages-from-mqtt-into-one-request-to-database/27915 "2020-06-06T20:10:34Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![SuperBoss9](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/superboss9/32/23462_2.png) [@SuperBoss9](https://discourse.nodered.org/u/SuperBoss9)\
**Post date:** [8 June 2020 18:18 UTC](https://discourse.nodered.org/t/combine-several-messages-from-mqtt-into-one-request-to-database/27915/15 "2020-06-08T18:18:37Z")

</div>

And fianlly it looks like this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/a/2a43d0e08d21effc9a403db20f78b6a4973a63e2.png)

With code similar to this:

```auto
switch (msg.topic){
    case 'Dacha/pressure':
        lLocation="Dacha";
        lArea="Pantry";
        lMeasurement="Pressure"
        msg.valid=true;
        break;
    case 'Dacha/temp':
        lLocation="Dacha";
        lArea="Pantry";
        lMeasurement="Temperature"
        msg.valid=true;
        break;    

```

And the sequence in the DB is also anrrow. I use keys to distinguish data. Actually I don't know wheeather it is good or bed. We will se when some amount of data is stored.

---

_[View the full topic](https://discourse.nodered.org/t/combine-several-messages-from-mqtt-into-one-request-to-database/27915)._