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; } } }

How do I write a report/filter that shows tickets assigned to me and resolved in a quarter

ckf

Hello. I do not know the reporting language at all, I've googled, but I am not finding what I am looking for.

Every quarter, I would like to run a report/filter to see list of all the JIRA tickets that were assigned to me, and that I resolved. So basically, If I run it on 10/1/19, for example, it will give me the applicable JIRAs tickets for the last 90 days.

However, If I run it on 10/18/19, I'd have to know how to specify the previous quarter, excluding the 18 days of October.

Thanks in advance to anyone who knows how to do this.

Accepted answers

Andrew Laden

You could use a JQL (Jira Query Language) query like

resolved >= 2019-07-01 AND resolved <= 2019-09-30 AND assignee in (currentUser())

A good trick to leave the JQL (jira query language) is to start by using the "basic" mode where you can use drop downs and such to build simple queries" and then switch to "advanced" so you can see the actual JQL that is generated.

(note: that query assumes that you were the assignee when it was resolved, and no one changed the assignee after the fact. If you resolved a ticket that wasnt assigned to you, or if someone changed the assignee after the fact, then this query would not catch it. Actually catching who made the transition would be trickier, and depend on your workflow)

All comments

Andrew Laden

You could use a JQL (Jira Query Language) query like

resolved >= 2019-07-01 AND resolved <= 2019-09-30 AND assignee in (currentUser())

ckf

Wow! That was quick. Thank you very much, Andrew!

Ste Wright

Just to add - you can history search on assignee - so if the assignee has changed, you could add "assignee was currentUser()" - finding both tickets which are and were assigned to you previously!

Ste

ckf

Thanks Stephen. I think the "was" is what I want.

Jack Nolddor [Sweet Bananas]

Hi ckf,
In addition to the suggested solution and supposing you are using Jira Server:

if you really want to query issues within real quartes (I mean not the last 90days) you can have a look to the endOfQuarter() and startOfQuarter() provided by JQL Booster Pack (FREE) with allow you to dinamically query issues within the current or past quarters of year.

Hope this helps,
Regards

ckf

Thanks!

Welcome!

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

Quick Links

Find more posts tagged with

jira