How to write a JQL for creating a filter to select sprint dropdown from particular project

[Deleted user]

I am working on dashboard, I want to know if I can have a filter for selecting sprints from the particular project? And, when such sprint is selected we must be able to view all the issues that sprint had.

[Bill Sheboy · Accepted solution]

Hi @[deleted] 

JQL filters search for issues, and not for any other entities, such as Sprints.

And even if that was possible, there are no built-in dashboard gadgets which display how you described.  A similar one with built-in features would be:

• add the two-dimensional filter gadget
• select your board's filter
• select Issue Type for the X-axis
• select Sprint for the Y-axis

That would allow selecting on the intersections to see the issues, by type, for the sprint.

If you need a different view with other functionality for dashboards, please check the Atlassian Marketplace for addon products: https://marketplace.atlassian.com/

Kind regards,
Bill

[Deleted user]

Hi @Bill Sheboy when I select sprint, I can only see it for present/open sprint. How can I view previous sprint? What is the query for that? Like we have opensprint() do we have one for previous sprint?

[Bill Sheboy]

The filter controls what is returned.  You could use a very simple filter like this:

project = yourProject
 ORDER BY Rank ASC

That would include all issues including the backlog ones.  

To limit to issues in current and prior sprints, please try this:

project = yourProject
 AND (    sprint IN openSprints()
       OR sprint IN closedSprints() )
ORDER BY Rank ASC