Searching Text for Domain Name

Chris Cotton October 3, 2023

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. 

2 answers

1 vote
Charlie Misonne
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 3, 2023

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!

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
October 5, 2023

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:

regex-search-email.gif

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 hierarchiesissue 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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events