Split email stored in labels custom field by domain

Question

Hello,

We have a process were we store emails in a custom field of type label.

We want to consolidate the data by domain, meaning that we should get domain from each label.

We are trying to do this with automation, so that a new field domain, of type label, is updated each time the emails field is updated.

do you think such a thing is feasible ?

Thanks for your advice!

Mirek · Answer

Hi @Patrice Champet

When you store emails in a custom field (which is a text field) then you can simply see how many tickets are in a specific domain by using JQL. I would be something like this..

project = ABC and custom_field_with_email ~ "companyA.com"

This would however not work when using a label since there is no such a feature OOTB

https://jira.atlassian.com/browse/JRASERVER-23038

Patrice Champet · Answer

Hi @Mirek

Thanks for your question.

Yes, this is the idea.

We have a custom field where we store a list of emails, to track each impacted "user" (they are not Jira Users). 
For instance:

* ISSUE 1 -> smith@companyA.com, foo@companyB.com 
* ISSUE 2 -> smith@companyA.com

We need to report on domains to have a clear view of the amount of issue per domain :

* companyA.com -> 2 issues
* companyB.com -> 1 issue

So we were trying to create a custom field, or scripted field, for Domain that could be automatically field with a substring of each impacted "user" value.

Mirek · Answer

Hi @Patrice Champet

Trying to imagine you proces but do not exactly know how to "store emails in a custom field of type label".

You mean if someone reports and issue you are trying to recognize the domain and put it in a label field? Is that correct?