Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,667
Community Members
 
Community Events
165
Community Groups

JQL to find issues that were changed (i.e. status, resolution) by anyone but not by the current user

I've gotten as far as this ...

project in (AB, DEF, GHI) AND resolution changed TO ("Won't Fix", Duplicate, "Cannot Reproduce", "Not A Bug", "Won't Do") AFTER startOfDay(-1) BY currentUser()

But, I want the issues that were changed by anyone except the issues changed by myself.

I've tried to implement a 'not' but it doesn't seem to work.

4 answers

1 accepted

2 votes
Answer accepted

Hello,

Try to add the NOT keyword before the resolution keyword:

project in (AB, DEF, GHI) AND NOT resolution changed TO ("Won't Fix", Duplicate, "Cannot Reproduce", "Not A Bug", "Won't Do") AFTER startOfDay(-1) BY currentUser()

Hi @Alexey Matveev _Appfire_ 

This returns issues which didn't have a change in resolution to the given resolutions.

Thanks, but not what I'm looking for.

You can add another condition:

project in (AB, DEF, GHI) AND NOT resolution changed TO ("Won't Fix", Duplicate, "Cannot Reproduce", "Not A Bug", "Won't Do") AFTER startOfDay(-1) BY currentUser() and resolution changed TO ("Won't Fix", Duplicate, "Cannot Reproduce", "Not A Bug", "Won't Do") AFTER startOfDay(-1)

0 votes
Bob Davis I'm New Here Jun 01, 2022

AND NOT status changed BY currentUser()

Ever get an answer on this?

Hi @Tom De Cock ,

I don't think that query will generate much in Jira as it is not really a JQL Query.

You can alter it to soemthing like this:

project in (AB,DEF,GHI) AND resolution in("Won't Fix", Duplicate, "Cannot Reproduce", "Not A Bug", "Won't Do") AND resolved>=-24h AND Assignee !=currentUser()

that query searches for issues in project (AB, BEF, GHI) witht he resolutions above, that transitioned into that resolution in the last 24 hours and were not transisioned by the user searching. This assumes however, that the assginee is the one closing an issue.

Hope this helps in what you're after.

Cheers

Merle

As for how to JQL this page from the documentation could be helpful: https://confluence.atlassian.com/jirasoftwareserver0713/advanced-searching-965542847.html

Also this blogpost could be a good read: https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql

Hi @Merle Fischer 

The query I posted works in Jira. I'm looking to change it further so that I only see issues where I'm not the person who made the resolution change.

Your proposal with assignee != currentuser(() isn't what I'm looking for.

Thanks though.

Like Merle Fischer likes this

Hi @Tom De Cock  sorry morning brain :P

Suggest an answer

Log in or Sign up to answer
TAGS

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