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

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.

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.

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}

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

906 views 3 9
Read article

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