Escaping special characters in Jira JQL Search

I seem to have the same issue as this person: https://answers.atlassian.com/questions/47338 (I'm using the advanced search however, and I'm planning the URL encode the JQL to use the REST API)

 

I am trying to find specific issues which the summary begins with "[QC TASK]".

I tried the following, which works, but also finds other issues I don't want, like one having the summary "have the QC tasks displayed"

summary~"QC TASK" and status="in progress"

 

This returns the exact same thing:

summary~"\\[QC TASK\\]" and status="in progress"

 

And if I don't escape the '[', it results a lot of things that I don't want.

 

How do I make this work properly? Another solution would be to use an operator "starts with" instead of "contains", does that exist? Or maybe even make the search case sensitive.

3 answers

1 vote

You can't do this in JQL.

ScriptRunner has issueFieldMatch, which you can use like this:

issueFunction in issueFieldMatch("", summary, "\\[QC TASK\\].*")

The first parameter is a JQL function to narrow down the issues where the regex will be run on the summary field.

Yes, this is the article I read for the reserved characters. I did exactly the same thing as in the example they gave, escaping the '[' and ']', but it still finds the other Jira ticket that doesn't match.

I must have been confused by this {quote} And if I don't escape the '[', it results a lot of things that I don't want.{quote}

It's a bug. Vote and watch it here: JQL queries with special characters [ ] returns incorrect results

 

Issue has been going on since 2011, this issue is "resolved" but Atlassian has a "\\[funny\\]" definition of resolved: https://jira.atlassian.com/browse/JRASERVER-25092

and it's because JQL implements Apache's Lucene search which strips all non-word characters.

 

you can use plugins to solve it looks like:

free:

https://marketplace.atlassian.com/plugins/proficient.developer.plugins.jira.power-jql/server/overview

 

or paid: "script runner" plugin.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot