Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,499,066
Community Members
 
Community Events
179
Community Groups

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

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?

3 answers

1 accepted

5 votes
Answer accepted
MJ Atlassian Team Jul 04, 2013

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.

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

Like Yatish Madhav likes this

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!

Like # people like this

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?

Like # people like this

Any update or workaround on this from Atlassian?

Like # people like this

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

+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.

2 votes

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.

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.

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

Can you comment @Renjith?

Normal issue navigator search.

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

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

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

I get no results back?

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

It works!

Thank you Renjit

1 vote
Jeison Atlassian Team Jul 04, 2013

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.

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.

Suggest an answer

Log in or Sign up to answer