Agent Workspace - corrupts SQL

image avatar

Darren Bell

Posted Jun 07, 2023

We have turned on Agent Workspace this morning and one of my agents is reporting he is unable to paste in SQL code from MSSQL v18.5.1 in to the Agent Workspace window without it being corrupted.

The code is 

SELECT * FROM AXVC --UPDATE AXVC SET AXVC_STATUS = 'P', AXVC_STATUS2 = 'P' WHERE AXVC_CO = '05' AND AXVC_STATUS = 'N'

 

but appears in Agent Workspace as (the _ symbols have been removed and the test italicised.

However, in the old, non-agent workspace, the same paste action works ok

We have tried this in our sandbox and got same results and also a 'clean' / different browsers.

The only way to get it to work is to surround the code with ```` at the start and end or paste it into a codeblock which adds to the keystrokes needed - which were not needed before.

Does not seem to have affected everyone though.

 

 

 

0

1

1 comment

Date
    Newest

      Official

      image avatar

      Amisha Sharma

      Zendesk Product Manager

      Hello Darren Bell - Thanks for providing feedback.

      This behavior is due to providing markdown support in Agent Workspace. Details here: https://support.zendesk.com/hc/en-us/community/posts/4799753297818-Need-feedback-on-the-release-of-a-Markdown-enhancement-in-Agent-Workspace 

      We SQL code, if copied from a plaintext source is treated as markdown syntax and converted upon pasting in our composer. There are a few workarounds you could use:

      1. Use Cmd + Shift + V while pasting instead of Cmd + V. Adding "Shift" would not convert it to HTML.

      2. As you mentioned, paste it inside code block instead.

      Hope this helps!

      0

      Official

      image avatar

      Amisha Sharma

      Hello Darren Bell - Thanks for providing feedback.

      This behavior is due to providing markdown support in Agent Workspace. Details here: https://support.zendesk.com/hc/en-us/community/posts/4799753297818-Need-feedback-on-the-release-of-a-Markdown-enhancement-in-Agent-Workspace 

      We SQL code, if copied from a plaintext source is treated as markdown syntax and converted upon pasting in our composer. There are a few workarounds you could use:

      1. Use Cmd + Shift + V while pasting instead of Cmd + V. Adding "Shift" would not convert it to HTML.

      2. As you mentioned, paste it inside code block instead.

      Hope this helps!

      0

      Sign in to leave a comment.

      Didn't find what you're looking for?

      New post