Microsoft SQL Node: Suspected Display Bug in JS Expression

[jzrts]

Hi,

I’m seeing some behavior in 1.15.2 where using [brackets] in the expression editor causes the preview of the resulting value to display differently than what the expression specifies. However the node still executes the correct value.

For example, with incoming $json:

[
{
"dbName": "Testing",
"queries": "MenuGetUsers"
}
]

And expression:

EXEC [dbo].[{{ $json.queries }}]

I expect it would display and execute:

EXEC [dbo].[MenuGetUsers]

It does execute that expected value. However in the preview, it shows:

EXEC [dbo][dbo].[{{ $json.queries }}][MenuGetUsers]

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[jzrts]

• n8n version: 1.15.2
• Database (default: SQLite): Postgres
• n8n EXECUTIONS_PROCESS setting (default: own, main): Default
• Running n8n via (Docker, npm, n8n cloud, desktop app): AWS EKS
• Operating system: AWS Linux

[Jon]

Hey @jzrts,

I think we have this issue already being tracked somewhere as it can also cause issues with other special characters as well. I will get this post linked up to the other issue post so you get an alert once fixed.