Special character issues - Url link update in dashboard and database - Postgresql

hi all, i am updating the url link in database through ui-text input node and postgresql, displaying ui-table.

example: http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1 this is the url, after updating, in the ui-table and database, it shows like below:
Where it is not accepting special characters.

SQL Query: INSERT INTO grafana_list (machine_name,machine_no,link,note) VALUES ('{{msg.payload.machine_name}}','{{msg.payload.machine_no}}','{{msg.payload.link}}','{{msg.payload.note}}');

http://localhost:3000/d/oJ65LywGk/dashboard-oee-1?orgId=1

requesting to support

use triple braces
{{{msg.payload.machine_name}}}
Then it will not convert html/special characters

1 Like

Thanks @E1cid , it is updating correctly., why three curly brackets are using?

If you read the help info for the node in the sidebar it explains that 3 braces tell the node not to replace html/special characters. Why, because that's how the node author configured it, probably so you can display the text on a web page, where the characters would cause issues.

It’s a “feature” of the mustache syntax library being used. See the mustache docs for details GitHub - janl/mustache.js: Minimal templating with {{mustaches}} in JavaScript

Thanks @E1cid

Thanks @dceejay

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.