Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


JQL for getting reporters with different domain email


We have detected that some users have been able to create tickets using emails other than the company's and I would like to be able to get all the tickets that were created with a reporter other than the domain (let's use as an example)

I thought about using "not contains" (!~) but it only applies to free text fields.

Do you know any other way to obtain this data?

Thanks in advance!

1 answer

1 accepted

1 vote
Answer accepted
Giovanni Melai
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 02, 2023

Hi @adelgadox-kvk,

I can't think of an easy way to do this directly with JQL, also because in Jira Cloud the reference to the users is not with the username/email but with the user ID. 

What I can suggest is to get the users IDs from the admin console. You can go to and select Directory. 

Now, if you have only a few users you can just open each of those and check the URL, the user ID is the last part of the URL: ...members/<User ID>

If you have many users you can export the full list in CSV and import it in gsheet/excel so that it's easier to filter the users. 

Once you have all the IDs you can use the following JQL:

reporter in (<UserId1>,<UserId2>,...)

 I hope this helps

Hi @Giovanni Melai ,

Yes, I thought the export to CSV could be a solution.

We have almost 8000 users but I think it will be easier to create a solution using Google Sheets from the CSV data.

Thanks Giovanni for this alternative of solution.

Like Giovanni Melai likes this

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events