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!
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 'firstname.lastname@example.org'. 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.
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"
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event