Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

2 questions : 1) how can I write the JQL of a jira hasn't been changed by some group ?

Hi, Madam/Sir, 

          Here I have 2 questions,please help , thanks .

1) For this JQL , the username is strange. someone is OK, but it will tell us some users don't exist though I do make sure they exist . Eg. User: amy.yang is ok, But, Odi Cai  are not ok for this JQL. Why ? 


2) JQL fixVersion in ("client 5.6.3", "client 5.6.3 bug", "client 5.6.3 cc") AND status = Closed AND status changed by (amy.yang)

If I hope to filt the group that didn't close the issue in some fixversions, how need I write the JQL ?


Thanks for your help 

Best Regards/Amy


1 answer

1 accepted

0 votes
Answer accepted
John Funk Community Leader Apr 15, 2021

Hi Amy - Welcome to the Atlassian Community!

By the way, your links go directly to your instance, which we don't have access to, and you really shouldn't share that information.  :-)

For number 1, I have seen that a few times, and I have no idea what causes it. The way to ensure it will always work is to use the account ID of the user instead of the username. 

I am not sure what you are asking in Number 2. When you execute the query, what is wrong with the results? Or what would you rather see? 

Hi, John, 

        Thanks for your prompt feedback . Yeah, you should have no access to our instance, my bad .

For number 1,  I will try account ID of the user as your suggesstion. 

For number 2,  in fact I 'd like to ask about this JQL :  Closed AND status changed by (amy.yang).  If I want to filter "NOT CHANGED BY SOME GROUP" , what SQL should I use ? Hope I expressed it clearly this time .

Best Regards/Amy 


John Funk Community Leader Apr 16, 2021

I am afraid you will not be able to do it directly with the status field. We have a post function on the transition to the Closed Status (or Done Status) that sets the Assignee to the current user. you might be able to capture the user who marked it closed in another custom field as well. 

Then your query would look something like this:

project = JIRA and status = Closed and assignee not in membersOf(administrators)

where administrators is the name of your group in Jira. 

Hi, John, 

      Got with thanks .



Like John Funk likes this

Suggest an answer

Log in or Sign up to answer
Community showcase

The benefits of using Jira in different departments

Jira is a great tool to use across different departments. Forget that paperwork – switch to Jira and get that tasks done smoothly. Marketing Jira allows for a complete digital transformation of you...

102 views 0 6
Read article

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