jira search

Question

I know that it is possible to search for text matches in the body of issues, for instance if I have a project titled Hello World and I have an issue associated with the Hello World project that contains the phrase Goodbye Charlie, I can create a search query to find all issues that have the word Goodbye using the query:

Text ~ Goodbye

I find that sometimes it works but there are references or portions that are not picked up....so i'm wondering if there is a wildcard or something that can be added or what suggestions there are out there?

example, I have a client contact email address in the body of a ticket, jonsmith@xyz.com. I want to find all references to any emails that have the same email domain xyz.com, how do I search for this?

Muhammad Ramzan_Atlassian Certified Master_ · Answer

For now there is  a work around using the plugin .

Here is the query

issue in fieldMatch("project in (helpdesk1) ", "Summary","*@gmail.com")

But you have to provide the project names where this search will work, or you can use any jql sub query other than project which is generic.

Actually below are the query requirements

issue in fieldMatch(jql-subquery, field-name, regexp)

Jon Lazzarino · Answer

Thanks Pavel,

I have added my voice to the ticket - https://jira.atlassian.com/browse/JRASERVER-6218

What I need and many others do to though is the ability to query using a wildcard at the start of the string....I need a query like:

text ~ "*@xyz.com"

which isn't supported...nor is any other variation.

From the ticket, I see that we're actually 14 yrs into it and still no progress, so I should set realistic expectations and instead of waiting for a fix, I should look for workarounds....

Does anyone have any workarounds or ideas around how to get something like this done?

In this particular case I'm looking to find all related email contact info so if there are tickets with abc@xyz.com,, cba@xyz.com , gfh@xzy.com I want to run a query to find them all...

I would appreciate if anyone has any good ones to share? Thanks in advance.

Pavel Junek · Answer

Hi @Jon Lazzarino ,

OK :)

You can use Wildcard *:

text ~ Good*

For your examle, you can try this:

description ~ john@*

Unfortunately, it doesn't work vice versa

description ~ *@xyz.com

Please see oficial Atlassian ticket - https://jira.atlassian.com/browse/JRASERVER-6218

Pavel