How to find tickets that I touched in some way ordered by date

[Robert Gelb]

I'd like to get a list of tickets that I worked on (possibly constrained by date).  And when I say worked on, I mean anything having to do with a ticket - adding a comment, moving it to the next stage in the workflow, changing the story points, whatever.

And I'd like the tickets sorted by the date that I affected the ticket.  Is this possible?

[Tayyab Bashir · Accepted solution]

You'd have to construct the JQL according to your need. 

For e.g. the following would return all the issue:
- you commented 
- changed status of
- was ever the assignee 
- was ever the reporter
- or ever added a worklog on an issue.

issueFunction in commented('by tbas') OR status changed BY tbas OR assignee was in (tbas) OR reporter was in (tbas) OR worklogAuthor in (tbas)

[Robert Gelb]

Your answer lead to towards the answer:

assignee was in (currentuser()) OR status changed by currentuser() OR reporter was in (currentuser()) ORDER BY updated DESC

Jira didn't know anything about `worklogAuthor` and it complained that ScriptRunner wasn't licensed when I attempted to run `

issueFunction in commented('by tbas')

`

[Tayyab Bashir]

worklogAuthor should work since that field is provided by default in JIRA.

worklogAuthor in (currentUser())

and to get issues which a user has commented on is not a default JIRA functionality, you'd have to access it via ScriptRunner plugin. 

You can generate a trail license and try it out. 

[Nick Machnik]

that's not an answer that's a work a round.

[me]

It is really too bad this is a query and not an interface like in TFS

Using Jira should not be extra work.

[NathanGlanzerONE]

If you want to do fancy stuff it will always be work. 

[C-Brian.Snider]

I would push back on whether or not this was a "fancy" feature... seems like core functionality to me. 🤷‍♂️

[elmnt]

Honestly, if I can't easily filter any of my data, with a few clicks, using filtering UI, then the software hasn't properly solved filtering. 😬

[karthik chengalvarayan]

The answer given by Robert 'assignee was in (currentuser()) OR status changed by currentuser() OR reporter was in (currentuser()) ORDER BY updated DESC' worked perfect for me. This is what i expected and i got the complete report which i use for every month status. Thank you Robert

[Samantha Fowler]

Same - I used it and it worked well! I just wonder if this includes or how to add 'watch' tickets.