pull a list of jira tickets in the active sprint using Jsql without using the sprint ID number?

[Juana Torres]

example  

sprint= activesprint()

[Ollie Guan · Accepted solution]

Hi @Juana Torres ,

I think searching by sprint id is the easiest way.

An active sprint may exist at the same time, so it is impossible to query the correct result through this condition.

Why don't you want to query through the sprint id?

[Juana Torres]

Hi Ollie, thank you for getting back to me.  I am creating filters that I use in  dashboards and I don't want to have to change the filters every time there is a new sprint, it will be very useful if you guys create a activesprint() function. So that I can use it on my JSQL as sprint= activesprint ().

[Ollie Guan]

Hi @Juana Torres ,

Whether the following query match your needs?

JQL:Sprint in openSprints() and project = xxx

[Juana Torres]

This is perfect! Thank you Ollie :-)

[Pankaj Kumar]

It works but I want to display the count of story in each sprint. How I do that?