Filter tickets by email

[Alvaro Moran Gago]

I want to create a JQL query that filters tickets by email domain. So, if I have a series of users, some with the email ...@mycompany.com I want to filter those with @mycompany.com

[Akhand Pratap Singh]

Hello @Alvaro Moran Gago ,

Good day, Welcome to Atlassian Community!!

I am not aware of native feature for this to directly allow you pull out tickets based on the Domain of the assignee/reporter.

But there is a workaround, you can use Combination of Automation for Jira and a custom field to get the domain of the reporter or assignee and then use filter option.

STEPS:

• Create a new custom field using Short text (plain text only) type and associate it with the service project. (I named mine "Reporter Domain")
• Create an automation rule to run When: Issue Created >>> Then: Edit issue fields and for my example provide the field name "Reporter Domain" and set the value to {{ reporter.emailaddress.substringafter("@") }}
• Turn the automation rule on and then any newly created issues should populate the field with the domain name of the reporter's email address.
• Filtering with JQL expressions can now be done on this field type with:

Referred from: https://jira.atlassian.com/browse/JRACLOUD-61425?focusedCommentId=3037398&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-3037398

There are Custom field called "Domain of Assignee" or "Domain of Reporter", but they are not visible on the new view, bug is raised with Atlassian: https://jira.atlassian.com/browse/JRACLOUD-74348

[Calvin]

There is a few options if you are using this in an automation, the other users solution is fantastic, or moving the reporter of the field into a variable or text custom field.

If you only need to do this once however and your already able to cut the list down a bit beforehand, I have just done a basic excel/csv export and filtered it that way.