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)
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,
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events