It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Search for part of username within JSD

Deleted user Jan 16, 2020

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,, 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!

1 answer

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.

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 ''. When I try to search for this exact string it does get the results. (It's in Dutch, but you'll get the idea).

Schermafbeelding 2020-01-17 om 08.33.31.png


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

Schermafbeelding 2020-01-17 om 08.33.56.pngSchermafbeelding 2020-01-17 om 08.33.45.png



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 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 = ""

Suggest an answer

Log in or Sign up to answer

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you