JQL to search for partial email test from an email address

[wesley hunter]

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_]

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.)

[Hannes Obweger - JXL for Jira]

Hi @wesley hunter

welcome to the community! Just to add to the previous answer, there's actually a number of options available in the Atlassian Marketplace. 

E.g., this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Any questions just let me know,

Best,

Hannes

[wesley hunter]

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 :)

[Manne Kjærby - ProProces]

Hi Wesley.

That is not possible out of the box.

You could use the issuefunction issueFieldMatch which comes with the app scriptrunner for Jira cloud.

Olga describes here how to do it:

https://community.atlassian.com/t5/Jira-Software-questions/Can-I-search-for-all-issues-created-by-users-with-specific-email/qaq-p/1737985

Scriptrunner issue function documentation:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

[wesley hunter]

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 :)