JQL special character search summary

[Eduard Diez]

Hello community:

I need special characters in exact phrase search.

I know that the advanced search does not currently support searches with special characters ((" ") + . , ; ? | * / % ^ $ # @ [ ]) so if there are any special characters within the exact phrase search, they will be ignored.

So I need to do a search like this:
summary ~ "[ICTO*"

The [ character is not accepted, how can I do the search?
Thanks

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Eduard Diez

I don't consider myself a top JQL expert, so if someone knows a native solution, I'm happy to stand corrected - but for now * you may need extra tooling for that.

• There's a number of apps in the Atlassian Marketplace that extend JQL. I've used JQL Search Extensions a few times and it works great, and I believe there's a function that allows queries like yours. There are several other apps, too.
• I myself work on an app named JXL for Jira that allows searching through a set of issues much like you'd do in e.g. Excel or Google Sheets. As it uses a different technology for that, I believe your query should work just fine. I'll add more information below.
• You can always export your issues to Excel and perform your search there, but I understand that this isn't quite what you're looking for.

* IIRC, Atlassian is actually working on improved text searching capabilities in Jira, so this may be natively supported sometime in the future.

[Hannes Obweger - JXL for Jira]

This is how this looks in action in the app that my team is working on, JXL for Jira:

Once you're narrowed down your list of issues, you can work on them directly in JXL, trigger various operations in Jira, or export them with just one click for further processing.

Hope this helps,

Best,

Hannes

[Eduard Diez]

Thanks @Hannes Obweger - JXL for Jira 

But the company wants something free, although your answer is good.

[mauricio.groth · Accepted solution]

Hi @Eduard Diez 

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your issues whose summary contains [ICTO*.

issue in wildcardMatch("summary", "[ICTO*")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

[Eduard Diez]

Hello @mauricio.groth 

Thanks for the information I will try to do it, but the query that you propose me the JIRA where I work does not recognize it.

[mauricio.groth]

Hi @Eduard Diez

Thank you for replying.

Have you downloaded our app and it is ready to use?

If yes, you have to use our functions inside the app.

Please follow these steps:

1. Go to apps
2. Click on JQL Search Extensions
3. Use the query

You can check our documentation for more information.

Please let us know if you have any further questions.

Best regards,

Maurício Groth

[Eduard Diez]

Thanks @mauricio.groth 

But the company wants something free, although your answer is good.

[Magdalena Zhisheva]

Hi @Eduard Diez ,

You may try to follow the tips in this article. 

Hope it helps!

[Eduard Diez]

Hi @Magdalena Zhisheva 

I have read the article and it does not work for me, thank you very much for your help but it does not works. In my case it does not work, I am looking for this:

summary ~ "\"[ICTO_\""

But JQL found some similar issues, but not exactly.

[Magdalena Zhisheva]

Hi @Eduard Diez ,

What if you remove the "[" character but with the same phrase search as: summary ~ "\"[ICTO_\"" ? Do you have more good results?

[Eduard Diez]

Hi @Magdalena Zhisheva 

I can't because there are many issues with that summary, but the ones I want are only the ones with the [ICTO, and not the ones with ICTO

Tanks