It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to query for issues that were flagged at some point?

Veller I'm New Here Oct 09, 2019

Hi peeps.

I'm trying to find all the issues that got flagged at some point in their lifespan. It might include those issues that are not blocked anymore.

Tips on how to do that using JQL?

For context: I feel most of the work my team does is dependent on other team's work. Eventually my team can't progress in the user story because it gets blocked until a third party provides us with something. I want to understand how many issues out of the total issues were flagged at some point in the process.

Ideally I would also like to know how much time issues were blocked on average out of the total cycle time of issues.

1 answer

Hi Veller - JQL doesn't support querying the change history for the Flagged custom field.  You will need to resort to an issue changelog reporting app such AIO Reports

If you have blocked as a status however you can use a number of JQL operators such as WAS and CHANGED.  You can use them on Assignee, Fix Version, Priority, Reporter, Resolution as well.

JQL only supports finding the set of issues that changed in a specific way during a specific period.  To get more insight you should check out the Time in Status app.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

314 views 1 3
Join discussion

Community Events

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

Events near you