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.
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.