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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do not see this resolution field in my configuration , how can I remove this field or setupwhen moved to done mark the field as resolved?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @James Stover
Welcome to the community.
It is unclear how your question relates to the original post.
Please start a new post and provide more information about the problem you are trying to solve.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.