Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL special character search summary

Eduard Diez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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

3 answers

2 accepted

2 votes
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
February 13, 2023

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
Atlassian Partner
February 13, 2023

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

special-character-search.gif

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

Like 2 people like this
Eduard Diez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

Thanks @Hannes Obweger - JXL for Jira 

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

1 vote
Answer accepted
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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.

aaaaaaa.PNG

Like Aleksandra Leesment likes this
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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

Like Eduard Diez likes this
Eduard Diez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

Thanks @mauricio.groth 

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

1 vote
Magdalena Zhisheva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

Hi @Eduard Diez ,

You may try to follow the tips in this article. 

Hope it helps!

Eduard Diez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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.

Like MRW likes this
Magdalena Zhisheva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

Hi @Eduard Diez ,

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

Like Eduard Diez likes this
Eduard Diez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2023

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

Like Magdalena Zhisheva likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, ace, atlassian community event, donation, girls who code, women in tech, malala fund, plan international, kudos, community badge, badge, atlassian badge, International Women’s month, International Women’s Day, women's month, women's day

10 for Change at Atlassian Community Events

Show up and give back by attending an Atlassian Community Event: we’ll donate $10 for every event attendee in March!

Join an Atlassian Community Event!
AUG Leaders

Upcoming Jira Events