JIRA - Resolved by me query

H

13

59

How to write query that will select only issues resolved by me.

I have found some old post that says its no possible, but it might have changed.

Hedonism answered 30/8, 2011 at 6:38 Comment(0)

S

68

Use next JQL: status was resolved by "username"

Strom answered 30/8, 2011 at 22:53 Comment(4)

STATUS was REOPENED and PROJECT in (A, B, C) and STATUS was RESOLVED by "daniel" works just fine... but is there a way to query something like STATUS was FIRST RESOLVED by ...? That's what I'd need... – Nicely 5/9, 2012 at 14:17

Check this out I'm not sure if this is something that might be of assistance to you or not: confluence.atlassian.com/display/JIRAKB/… – Strom 16/9, 2012 at 2:37

project = prohjectname AND status was "Resolved" by username and resolutiondate >= '2014/01/08' and its variants exists in jql now i am not sure whether they existed at the time question was asked. – Malonis 3/9, 2014 at 7:27

Shouldn't it be status changed to Resolved by "daniel"? 'Changed by' works for me instead of 'was'. – Traver 16/2, 2015 at 14:59

T

40

In 4.4 this seems to work:

status was "Resolved" by currentUser()

More details can be found here.

Tena answered 27/9, 2011 at 21:47 Comment(0)

C

8

The answer most often given is to use JQL for something like

status was Resolved BY currentUser()

While all fine and good, this will give you back all the issues that you have ever resolved. That is, if you resolved issue FOO-1966 and then it got reopened and someone else resolved it again it is still an issue that was resolved by you.

Here's a better way to do this in JIRA 6 and later (including JIRA onDemand).

Create a custom field called "Resolver". Make it a person field but do not add it to any forms (unless you really want to).
Edit your workflow and add a post function to the resolve issue transition in your workflow. Make the action "Update custom field" and set the Resolver to %%CURRENT_USER%%.
Publish your workflow.

Now whenever someone resolves an issue using that workflow, the Resolver field will get set to the current user. Now the Resolver field is semantically "last resolved by".

As an added bonus, you can use the value in the Resolver field to reassign issues back to the person who resolved them when they get reopened. I'll leave this as an exercise to the reader. :-)

Caughey answered 27/12, 2013 at 22:58 Comment(0)

E

4

You can use this JQL query:

 "Resolved by" = currentUser()

(I just verified this in v4.1.2#531 on a standalone version)

There is also a plug in you can use in older versions: https://studio.plugins.atlassian.com/wiki/display/JQLT/Home

Escaut answered 30/8, 2011 at 7:48 Comment(4)

Resolved by is this custom field or out-of-the-box? I ask because in mine 4.2.1#b588 there seems to be no such field (I tried both simple and advanced search) – Jidda 30/8, 2011 at 11:54

I see thanks. cf[10038} - here, cf seems to denote custom field indeed – Jidda 31/8, 2011 at 7:3

I am having JIRA (v4.1.2#531) but this query does not work for me. Says Field 'Resolved by' does not exist. – Chickenhearted 25/2, 2014 at 5:55

@KuldeepJain Same error message with JIRA v6.3.10 when this query is run. – Korten 7/10, 2015 at 12:59

M

2

None of the above worked for me on JIRA (v4.1.2#531)

However, his works:

"Resource" = currentUser() AND (status = Fixed OR status = Closed OR status = "No Change Required") ORDER BY updated

Meridethmeridian answered 9/5, 2012 at 19:55 Comment(0)

M

1

You can use the WAS operator:

JIRA - Advanced Searching : "The "WAS" operator is used to find issues that currently have, or previously had, the specified value for the specified field"

Example: status WAS "Resolved" BY currentUser()

Mica answered 9/8, 2012 at 10:32 Comment(0)

H

1

For JIRA v6.3.4, this worked for me:

"Resolved By" = currentUser()

Heaviness answered 14/11, 2014 at 15:45 Comment(0)

N

1

I guess you can use this

status in (resolved) AND component = COMPONENT_NAME AND assignee in (currentUser()) AND resolved > -1d

but the new thing here resolved > -1d this to get the issues that are resolved me in this day

resourses: https://community.atlassian.com/t5/Jira-questions/JIRA-4-4-search-filter-how-to-find-issues-resolved-in-last-seven/qaq-p/77326

Nagle answered 28/11, 2017 at 9:19 Comment(0)

J

0

As far as I can tell, search for resolved by me and more generally, for status changes, is not possible until at least JIRA 4.2.1 (the version I'm using now).

Search and JQL enhancements outlined in 4.3 and 4.4 release notes look like the move in the right direction (WAS operator) but I'm not holding my breath.

Jidda answered 30/8, 2011 at 7:39 Comment(0)

F

0

None of the above solutions worked for me. I started adding a label to all my issues to resolved_by_kishore, then in advanced search, I'm using lables=resolved_by_kishore. It's working fine.

Frolicsome answered 25/9, 2012 at 6:23 Comment(2)

What version of Jira are you using? – Syzran 23/1, 2014 at 19:13

It was old version. After we migrated to new version, these was and is are working. – Frolicsome 11/2, 2014 at 13:29

M

0

project = prohjectname AND status was "Resolved" by username and resolutiondate >= '2014/01/08'

and its variants exists in jql now i am not sure whether they existed at the time question was asked.

i am adding this answer so that if anyone comes here can find the answer

Malonis answered 3/9, 2014 at 7:28 Comment(0)

S

0

The values used in Status can vary (e.g. Resolved, Closed, Done, ...) so it is not reliable to use.

Instead, use resolution:

resolution changed from EMPTY by currentUser()

Scavenge answered 12/5, 2022 at 19:47 Comment(0)

A

-1

Using = EMPTY seems to work for searching for empty custom fields with newer versions of Jira

Antin answered 26/3, 2014 at 18:58 Comment(1)

Please check if I have formatted the relevant query correctly (BTW I have not downvoted the answer) – Nigeria 26/3, 2014 at 19:19

Recommended topics

Hot tags