Searching Text for Domain Name

Question

I'm attempting a text search to see if a domain name has been requested for a blacklist. The domain is included in a recent issue. I need to find the original request to blacklist.

I attempt to search text for "example.net" and I get no returns even though I have a request that is currently open with "123456@example.net" in the description. Since I am not sure what the exact address would have been requested for a blacklist of the domain, I'm needing to search for the domain only.

Example searches I've tried with no luck:
text ~ "example.net"
description ~ "\"example.net\""
text ~ "*example.net"

I'm wondering if the issue is that the full email address is showing as a link in the issue instead of text only? In my mind, I should be seeing at least the open issue with the domain "example.net" in the description field.

Hannes Obweger - JXL for Jira · Answer

Hi @Chris Cotton

just to add to @Charlie Misonne's answer, another thing to consider is the Atlassian Marketplace; there are a number of apps available that either extend JQL or provide their own, more powerful ways of searching.

I can only speak for the app that my team and I are working on - JXL for Jira - but here, your use case would be trivial to solve:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after.

There's also the option to do a regex-search across all columns of your sheet.

Any questions just let me know,

Best,

Hannes

Charlie Misonne · Answer

Hi Chris!

What you need in theory is a wildcard search where you can put the wildcard in front of your keyword.

Like this: text ~ "*example.net"

Unfortunately Jira's search engine does not support wildcards as first character. You will get: '*' and '?' are not allowed as first character in wildcard query.

If this is a 1 time requirement you could export all your issues as CSV and use a spreadsheet or even a small script to find the results.

If this is a permanent requirement you could ask users to fill in the email address in a separate dedicated text field. With an automation rule you could extract the domain from the email and save it in another text field. This will allow you to query for domains.
Not sure if it fits your use-case 100%  but I hope it helps!