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

[learnobyte]

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

[E1cid]

@learnobyte

{{msg.payload.machine_name}}

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

[learnobyte]

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

[E1cid]

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.

[dceejay]

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

[learnobyte]

Thanks @E1cid

[learnobyte]

Thanks @dceejay