I have various fields from the results of a database search returned in, msg.test1[0]xxx where xxx are the field names, the data is in the name, field value notation from the view in debug.
How do I mix the information from the database with static information?
I was thinking something along the lines of
script
variable-name = {{msg.test1[0]FirstName}}
/script
h3 Hello /h3 variable-name '''
or even
''' h3 Hello /h3 {{msg.test1[0]FirstName}} '''
Sorry I could not get the page formatting above for the code right
I have looked in a debug node and all the fields with the contents of the variables are present.
I am using HTTP in post mode, then function node to setup database search details, followed by the database node to get the details, < I then pass those details through a function node to change from msg.payload to msg.test1, as the orange template node needs to use the msg.payload field from what I understand>. The static and dynamic data is merged in that template node, in default setup with moustache mode, I gave played with modes but none worked for me, it is then sent to an HTTP out node, to produce another web page with live data.
I am just unable to get any of the dynamic data from the database search to show up.