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, email@example.com. I want to find all references to any emails that have the same email domain xyz.com, how do I search for this?
Hi Jon - Welcome to the Atlassian Community!
You don't have to put project in the search/filter. You should simply have summary ~ goodbye.
However, only certain fields have the ability to do text searches. See this documentation for more guidance:
If you need specific syntax help - just post exactly what you are looking for. :-)
I hope that helps!
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?
I would appreciate if anyone has any good ones to share? Thanks in advance.
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)
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event