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

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.

3 answers

1 accepted

1 vote
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 _cPrime_ 

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)

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

Like Merle Fischer likes this

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

Ever get an answer on this?

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