Is there any way to search for a certain email address domain?

[Warren McInnes]

Hi,

Is there any way to search for a certain email address domain?

E.g. assignee ~ "@domain.com" or reporter ~ "@domain.com"

Can anyone advise?

[MJ · Accepted solution]

No this is not possible. Since the email address is not a value within the issues them selfs, or a field, but rather related to a user, you can not use it for issues queries, unless the username and email address are the same.

[Warren McInnes]

Alright thanks. Would have been nice to be able to do this?

[Mohamed Cherif]

Absolutely. This question was asked back in 2013, do we have any update for it today? (I need to search for issues assigned to people with email addresses containing "@domain."

Thanks!

[Yatish Madhav]

7 years later and I would also love to do this. Not only by domain - but also by email. Eg JQL suggests assignee or reporter name and email but populates the user account id.

Any update or workaround on this from Atlassian?

[Lina Johanna Quintero Prada - Ceiba Software]

Any update or workaround on this from Atlassian?

[Will_y_ De Vos]

Need also this functionality.

Starting to use the 'organizations' field, so I want to add all 'existing' customers that mention (field = reporter) the domain 'organization.com' & 'eu.organization.be' to organization 'organization'. 

Therefore I need a query that can filter on all these tickets containing that 'part of the reporters field' and then bulk change them to a certain organization.

Or is there a better way of accomplishing this?

Thanks, Will

[Fianna O_Brien]

+1 to providing a basic functionality for filtering by reporter email domain. Using the reporter ID for filtering is painful, cumbersome, and prone to failure. I just have to slowly add reporter IDs for every address associated with an organization to filter? That's incredibly painful.

[Renjith Pillai]

Add a scripted field (and call it any name) (https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner) and add this code:

return issue.reporter.emailAddress.split("@")[1];

Then search using this new field.

[Warren McInnes]

Hi Renjith,

Once I add this field, in the search do I search for the domain after @, so excluding the "@"?

Thanks, Will give this a try.

[Warren McInnes]

Where and how do I search once i've created this scripted field?

[Warren McInnes]

Can you comment @Renjith?

[Renjith Pillai]

Normal issue navigator search.

I am guessing you have selected text searcher while configuring the scripted field.

[Warren McInnes]

I selected text searcher yes, But when i make an issue navigator search:

"Email Domain searcher" ~ "@domain.com"

I get no results back?

[bogdan_martin]

"Email Domain searcher" ~ "domain.com" is the correct way to search

[Guillermo Robaudo]

Thanks Renjith

[Milos Pejkovic]

It works!

Thank you Renjit

[Jeison]

Warren, in addition Mick's answer, the assignee and reporter fields do not support the 'contains:~' operator, as they're not free text fields.

You might want to try creating a custom free text field to be filled with the email addresses of the issue participants, and that would be searchable.

Hope it helps.

[Warren McInnes]

Thanks Jeison, I knew the assignee and reporter fields do not support the 'contains:~' operator, I was just using it as and example, hence the "E.g". None the less, thank you for your help.