# Read SQL value and convert to Domoticz MQTT Topic - payload issue

**URL:** https://discourse.nodered.org/t/read-sql-value-and-convert-to-domoticz-mqtt-topic-payload-issue/14504
**Category:** General
**Created:** [19 August 2019 20:48 UTC](https://discourse.nodered.org/t/read-sql-value-and-convert-to-domoticz-mqtt-topic-payload-issue/14504 "2019-08-19T20:48:20Z")
**Posts on this page:** 1
**Showing post:** 24

<div class="post-metadata">

### Author: ![drmibell](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/drmibell/32/8424_2.png) [@drmibell](https://discourse.nodered.org/u/drmibell)
#### Post date: [22 August 2019 20:50 UTC](https://discourse.nodered.org/t/read-sql-value-and-convert-to-domoticz-mqtt-topic-payload-issue/14504/24 "2019-08-22T20:50:21Z")

</div>

> [@Steve-Mcl](#):
>
> Wish I had some kind of automatic macro reply for the amount of times this comes up. Same with "I have 2 values from 2 nodes I need to add together..."

Not long ago there was some [discussion](https://discourse.nodered.org/t/template-for-how-to-share-code/12227) of a plugin for Discourse that can be used to create templates for replies like "how to share code", "what versions are you using?", and now these topics. I know the developers have better things to do than tinker with forum mechanics, but this feature, if used tactfully, could remove a minor irritant and help get new users more complete answers quickly.

---

_[View the full topic](https://discourse.nodered.org/t/read-sql-value-and-convert-to-domoticz-mqtt-topic-payload-issue/14504)._