Escaping multiple characters in a JQL using smart values

Question

Need help please.

I am using the following in my Automation Rule to find newly created duplicate tickets and close them.

Summary ~ {{issue.summary.asJsonString}} and Type = "Security Incident"

This work well with Summary values without any special characters.  However, for example, if the Summary is: "Microsoft Defender error - check guideline:  Do you have access?", I get the following error:

Unable to parse the text 'Microsoft Defender error - check guideline: Do yo have access?' for field 'Summary'.

Thanks!

Doods

Duc Thang TRAN · Answer

Hello @Sergei Troshin

No, I haven't, and I don’t usually use asJsonString.

However, after testing, I noticed this smart value automatically adds quotation marks ("") in the JQL. So, for my suggestion, it ends up adding an extra set of quotation mark and not worked as expected.

After testing,  your suggestion it the best solution (searche text normal don't work this case)

Sergei Troshin_usua2u · Answer

Hi @Duc Thang TRAN

Have you tested this:

Summary ~ "{{issue.summary.asJsonString}}"

expression?

I've tested and it seems that it is not working properly.

Duc Thang TRAN · Answer

Hello @Doods Perea

Since your request contains multiple words, you need to add quotation marks ('')

Summary ~ "{{issue.summary.asJsonString}}" and Type = "Security Incident"

Or you can using the jql exact as @Sergei Troshin  suggested

Best,