JQL to search for partial email test from an email address

Question

I have a project where we receive tickets from 3 different clients, each ticket has the clients email addresses but the 3 domains are different.

I am trying to create a filter to search the tickets for "just the domain of the email"

For example: Email is - abc.123@none.com

How can I get JQL to search for just "@none.com"?

I am running the search against the text field to ensure It checks all fields for the email.

So would expect something like - text ~ "@none.com" but this does not work.

Thanks

Aron Gombas _Midori_ · Answer

Another option is to export the issues to an Excel spreadsheet using the Better Excel Exporter, and to filter them on the "Reporter" column:

Excel provides very handy features for filtering. Or, you could even define a new column for the email domain and extract the part after the '@' to that column using a formula.

Or, even introduce your own calculated field! It is easy.

(This is a paid and supported app developed by our app. Free for 10 users.)

wesley hunter_val4k3 · Answer

Thanks Hannes

I will take a look at this and any questions will let you know.

Isnt it funny how sometimes what we think will be a simple query turns into a rabbit hole :)

wesley hunter_val4k3 · Answer

Hey Manne

Many thanks for the reply. I had a look at scriptrunnerbut it seems to want to add it for all our users, (81 in total), yet only a handful of my team would utilise this.

I will need to look into why it wants to add the product for all our users as I would really only want to add the free version for a handful of users or a group of users.

Sorry if this is obvious and im just missing it but very new to Jira and only just started checking out what its capable of :)