Basically I want to access SQL node each fields from dashboard to enter data. Therefore is it possible to access those fields from outside the SQL node ?
eg: accessing name from function node like "msg.name".
any help would be really appreciated
please see the image
It is not possible to dynamically set a connection from dashboard or messages. The connection is a shared config object setup at design time.
However, if you are using
node-red-contrib-mssql-plus you can use environment variables for those fields.
Oh okay. I will try with that. Thanks for the reply as well as the solution.
note - environment variables are only evaluated at deploy time - so you have to restart Node-RED to reload any changes.
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.