JQL query to get report for 5 months

[tech_nagesh17]

Hi Team,

Please advise query to get how many reports were completed since from the last 5months.

[Graham Twine]

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")

[tech_nagesh17]

Hi @Graham Twine 

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)

[Callum Carlile _Automation Consultants_]

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)

[tech_nagesh17]

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)