How to write JQL filter to find the last month JIRA issues

[Sreenatha Reddy J]

We have status called "Build Released" so after this status we have different statuses so issues will move to different statuses, But I need to track how many issues were moved to the Particular status "Build release" at end of the month, Also I need to find how many issues are moved to same status in 1st 15 days and last 15 days of the month separately. 

Also, Please provide me the filter to find total issue created, done and closed last month, also need filter to find the user wise data done in last month and we should get the email notification  with this data.

[Craig Nodwell · Accepted solution]

Hi @Sreenatha Reddy J welcome to the community.
I'd start here:
What is advanced searching in Jira Cloud 

There's many date functions:

As for getting emails look into Filter Subscriptions.
Have a look at this Blog post:
JQL: Using filters and subscriptions 

Once you get started if you run into roadblocks please circle back with your details.

Thanks and once again welcome.

[Craig Nodwell]

Oh and I found this great blog posting that you might want to have a review of it might help.

Master Advanced Historical Operators For JQL Search 

[Sreenatha Reddy J]

Thank You @Craig Nodwell , I have used the above functions which you suggested and I got the expected outcome. 

JQL: 

Project in (A,B,C) AND status changed TO "ABCStatus" during (startOfMonth("-1M"), endofMonth("-1M")) ORDER BY updated ASC

[Craig Nodwell]

Yayyyyy
Now you're on your way to being a JQL Jedi.

-CN

[Mariana_Pryshliak_Saasjet]

Hello @Sreenatha Reddy J 

There are 2 add-ons from the Atlassian Marketplace, that can be helpful.

Issue History shows all the issue's changelog. By switching to the Chart view, you

ll get the info on how many issues have moved to the Particular status during a chosen period.

Also, Time in Status for Jira Cloud add-on generates a Status Entrance Date report, that shows the date when an issue has entered each of the statuses.

Choose the one that fits your need the best. 

Also, you can export a generated report to CSV or XLSX files. It's developed by my team and is free for using up to 10 users. Please, let me know if you have any questions.

[Yuliia_Borivets__SaaSJet_]

Hi @Sreenatha Reddy J 

Here is an article that can be handy:

History searches with & without JQL [10 examples]