Filter for closed, open user stories/bugs

[Jean-William Claxton]

Hello, 

I would like to create a dashboard that shows four different types of filters but I don't know the jql and get errors when I try to make my own. 

Here are the three that would be nice to have. 

- Tickets that have been put in the done collumn

- Tickets that have been removed from the sprint

- Tickets that are blocked (flag)

- How long tickets spend in a certain collumn

[Trudy Claspill · Accepted solution]

Hello @Jean-William Claxton 

Welcome to the Atlassian Community!

There is quite a bit of documentation on how to create searches. You can find it here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/

For using search results in Dashboards you will need to create the filter and save it. Then in a Dashboard you can add the Filter Results gadget and select the saved filter to display the results. You will have to add a Filter Results gadget for each saved filter you want to display.

- Tickets that have been put in the done collumn

The "done" column will have Status values mapped to it. To find those issues you would use the JQL

status in (<comma separated list of the Statuses you have mapped to the "done" column>)

Note that will retrieve all issues in those Statuses. It will not be limited to only the ones that are currently shown in the "done" column.

- Tickets that have been removed from the sprint

Jira does not have a JQL function to enable you to find the issues that have been removed from a specific sprint. There is a change request for that here:

https://jira.atlassian.com/browse/JRACLOUD-75868

I have not yet found a third party app that provides a function for this for Jira Cloud. Adaptavist Scriptrunner has a function for it, but only in their Jira Server/Data Center product.

- Tickets that are blocked (flag)

You can add the "Flagged [Checkboxes]" field to JQL for this.

 "Flagged[Checkboxes]" = Impediment

Specify the name associated with the Flagged checkbox on the right side of the =

- How long tickets spend in a certain collumn

Jira does not provide a specific report for this. You would need to use a third party app to get this information. The following search for the Atlassian Marketplace provides some options:

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=time%20in%20status

[Jean-William Claxton]

Great, I'll have a look. Thanks !