Is there a way in JQL to extract the domain part?

[Arnis Riškovs]

Hi,

Is there a way in JQL to extract the domain part (which follows the "@" symbol) from a Reporter email address? If so, what is it?

[Sebastian Krzewiński · Accepted solution]

Hi @Arnis Riškovs 

Unfortunately, JQL like that don't exist.

IMO what you can do is to create automation rule that will catch reporter email address and cut domain part by some text operations (https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/) and store it in other field. Rule can be triggered when ticket is created.

Regards,

Seba

[Barnali Putatunda]

Hi @Arnis Riškovs ,
You may use automation rule in Jira to extract the domain of the reporter.

You could make use of substringAfter method of Automation Smartvalues

{{issue.reporter.emailAddress.substringAfter(„@„)

Good luck!
Barnali
 

[Arnis Riškovs]

Thanks!
It works

[Lucas Modzelewski _Lumo_]

Check if Organizations might be what you’re looking for:

https://support.atlassian.com/jira-service-management-cloud/docs/use-email-domains-to-automatically-group-customers-into-organizations/

Once you set that up, you can use JQL filters based on organizations or customer details to segment and manage your queues more effectively:

https://support.atlassian.com/jira-service-management-cloud/docs/create-queues-based-on-customer-details/#Customer-JQL-functions

[Arnis Riškovs]

Instead of organization, we use special custom field due to specific circumstances.