Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Filter for closed, open user stories/bugs


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

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 06, 2023

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:

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:

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:

Great, I'll have a look. Thanks ! 

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events