How do I ask JIRA "what bugs have I modified in the last X days?"

Title says it all: How do I ask JIRA "what bugs have I modified in the last X days?"

10 answers

1 accepted

14 votes
Henning Tietgens Community Champion Apr 24, 2013

You can search for all issues you have transitioned in the last to days with this JQL

status changed BY username AFTER -2d

But this does not work for "updated" or "updateDate". For the current versions of JIRA the history operators can only be used with the Assignee, Fix Version, Priority, Reporter, Resolution and Status fields.

Henning

The answer is seemingly "You can't". Even though that information exists somewhere (you can see it in the bug history) you can't search for it.

Too bad. When I had that search in one of the previous bug trackers I used, I would use it all the time.

What if you watch your issues?

 

project = <project> AND updated >= -7d AND watcher = currentUser()

The closest I could come to the requirement is:

1) Status changed by user within last x days

2) Created by user within last x days

3) Assignee changed by user within last x days

(status changed BY currentuser() after -8d) or (created &gt;= -8d and creator = currentuser() ) or (assignee changed by currentuser() after -8d)

Still not covered: Commented without change of status or assignee

Note: At least the "assignee changed" part of the query seems to work weird with the dates, you might want to increase the required number of days by 1 to really catch all issues

There is a JIRA suggestion for this feature: https://jira.atlassian.com/browse/JRA-15235 you may vote for it, but it is an old request.
As for now, and what I see, the nearest you can get to this is using the JQL Mykola Novik posted.

Alternatives

Use the Activity Stream Gadget in a private Dashboard

ActivityStream.png

Use a Database Query if you have access to the database

In analogy to the Activity Stream Gadget, it queries the item-history, but you've got more options for filtering, grouping, etc.

The result looks like:

ItemHistoryResult2.png

select ji.issuekey, ji.issuetype, cg.author, cg.created changedate, ci.field, ci.oldvalue, ci.oldstring, ci.newvalue, ci.newstring
from changegroup cg
join changeitem ci on (cg.id = ci.GROUPID)
join (select ji.id, p.pkey||'-'||ji.issuenum issuekey, ji.summary, it.pname issuetype, ji.created
      from jiraissue ji
      join project   p  on (ji.project   = p.id)
      join issuetype it on (ji.issuetype = it.id)
      ) ji on (cg.issueid = ji.id)
------------------------------      
where author = 'your.user.name'                      -- modify user
and cg.created &gt; to_date('08.08.2016','dd.mm.yyyy')  -- modify date
and cg.created &lt; to_date('10.08.2016','dd.mm.yyyy') 
and issuetype in ('Bug','Story','Epic')              -- modify issuetype
------------------------------
order by cg.created

You will have to use filter

Example : issuetype = Bug AND updated >= -2d

For more details refer - https://confluence.atlassian.com/display/JIRA/Advanced+Searching

Thanks, but that's not what I'm asking. I only want the issues which I have changed, not all issues which have been changed by anyone.

In JQL you can search if Status/ Resolution is changed by X user, but this doesnot mean whatever X user has changed.

issuetype = Bug AND updated >= -2d and status changed BY X USER

1 votes

I don't think you can do this directly, other than by reading your activity stream in your profile.

Chaithra's answers are close, but the problem is that Jira searches by issue, not by person, so "all changes made by X" queries are rather hard to construct.

I think this needs some JQL coding...

You can do assignee WAS currentUser() but the problem with that is you'll see any issue that you've been assigned to at some point. So not ideal, but closer.

This was very helpful for me. I could then use fixVersion to see all issues that had been assigned to me in the current release (or a previous release). Thanks!

 

This data is right on the UI, and clearly of significant interest to users but you can't extract it.

Not thought out.

This worked for me:

assignee = currentUser() OR reporter=currentUser()

to find all the stories and issues changed by current user since the project

just add AND updated = StartofWeek() at the end and gives you weekly changes

 

Doesn't work. I've got a bug I worked on and assigned to a colleague, your search won't find it.

Toolkit is the one that works closed . It provides field LastUpdatorCommentor which will show value of last user edited or commented whichever is latest

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,775 views 11 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot