Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Query for how many issues were flagged in a particular month

Javan Asimba February 10, 2023

Hello, i am trying to search a query that will provide me with flagged issues for a particular month.

For example: how many issues were flagged in the month of January. The only dates available on my filter results are: updated date, created date and last status change on date.

 

 

 

Thanks

Javan 

3 answers

0 votes
John Funk
Community Champion
February 12, 2023

Hi Javan - Welcome to the Atlassian Community!

Unfortunately, there is no history function on the Flagged field. So getting Flagged = Impediment will only show you issues that are currently Flagged, not issues that were Flagged at anytime during the month, year, etc. 

So, you will probably need to create a custom field (hidden from the Edit and View screens) and set a value for the field when the Flagged field is updated to Impediment. Then you simply run a filter for the value of the custom field and your date ranges. 

0 votes
Craig Nodwell
Community Champion
February 10, 2023

Hi @Javan Asimba welcome to the community.  
You can't get directly to this but you can find some ways around it.
You can try something along these lines (of course you can change the date function)
Example:
Flagged = Impediment AND updatedDate >= startOfYear()

0 votes
Mohamed Benziane
Community Champion
February 10, 2023

Hi,

Welcome to the community

This is not possible, you can't find out when a issue was flag using JQL, you will need to look at the history of each issue.

Suggest an answer

Log in or Sign up to answer