Hello @tech_nagesh17 have a look at startOfMonth(), startOfWeek(), endOfMonth() etc. as described here
Find all new issues created in the last 5 months since the start of this month.
created > startOfMonth("-5")
I have tried with the below command, but using this command i only can see tasks completed since from last 5 months however we want to display the reports sprint wise. Is it possible to get. Please advise.
project = "Jira & Confluence" AND Sprint in closedSprints(-5m)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @tech_nagesh17 - just to confirm, do you mean you want to report on the number of issues completed within the last 5 months?
There is no short-hand JQL for months, but you could add something like resolved >= -20w to your JQL (this will only work if your completed issues have a resolution set for them. Here, I have used 20 weeks which loosely equates to 5 months)
Or if your issues do not have a resolution set for them, you could use status changed to Done after -20w (you can change 'Done' here to match whatever resolved workflow status you want to report on)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Callum carlile,
I have tried with the below command, but using this command i only can see tasks completed since from last 5 months however we want to display the reports sprint wise. Is it possible to get. Please advise.
project = "Jira & Confluence" AND Sprint in closedSprints(-5m)
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.