Search for part of username within JSD

[Deleted user]

We have a centralized internal Servicedesk that serves different companies. Our customers are the employees within those companies. They have different mail addresses for different companies (like xxx@domainA.nl, xxx@domainB.nl, etc.)

We want to create a report that tells us how many issues were created from those companies. Within the query I wanted to search for something like (reporter ~ DOMAIN), but it says that '~' is not a valid operator.

Any suggestions on how to solve this problem? Thanks!

[Alexander Schmidt]

The ~ operator is reserved for text fields.

As a workaround you could create an additional jira field and copy the Company name into this field in a postfunction. Then you can search it without needing that operator.

[Deleted user]

Hi Alexander, 

Thanks for your reply.

This doesn't get the results I was looking for. You can see that I created a testissue with 'mailadres' that has value 'test@domain.nl'. When I try to search for this exact string it does get the results. (It's in Dutch, but you'll get the idea).

But when I try to search for a part of that text like 'test' or 'domain.nl', I don't get any results.

EDIT: what about all existing issues? We have around 300 issues, which won't have this field. This would mean I would have to update all those issues. An automation rule can't happen, because you can't update a field, based on the value of another field.

[Alexander Schmidt]

Hi,

On the second field you would only add the Domain and not the whole mail address, then you don't have to search this way.

With the App https://marketplace.atlassian.com/apps/23337/elements-connect-formerly-nfeed for example you could create a Field which reads the reporter, and then with a Regex expression only displays the Domain.

Then you would search domain = "domain.nl"