nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

unknown

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.

Accepted answers

Alexey Matveev

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

All comments

Merle Fischer

Hi @[deleted] ,

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

Alexey Matveev

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

unknown

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.

unknown

Hi @Alexey Matveev

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

Thanks, but not what I'm looking for.

Merle Fischer

Hi @[deleted] sorry morning brain :P

Alexey Matveev

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)

unknown

That did the trick, @Alexey Matveev .

Tony Jannotta

Ever get an answer on this?

Bob Davis_qypwap

AND NOT status changed BY currentUser()

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server