While migration to DB2 I have to add many extra nodes to set the msg.payload to the value that the DB2 text node needs. In DB 1 it was possible to give the text node the where to take value from {msg.anything.anyvalue}. like here in the:
There are plans to do something similar, but more flexible, in DB2, to avoid the need for the templates, but at the moment that is the way it is, unfortunately.
It comes up a lot. The core Node-RED template nodes are cleaner than function nodes, but I appreciate it overcrowds the flows with extra nodes.
The driver behind our decision is that it also permits access to flow., global. and is consistent with how you could inject custom HTML here too, i.e. making the piece of text a link.
The idea of the value field opens up a lot of security vulnerabilities, and it's something we've avoided investing time into for other priorities at the moment. That said, it is proving difficult to keep ignoring.