How to do a filter on sprints ?

[Manon Ledda]

Hello again Atlassian community !

Today I struggle with setting a filter on "current sprint" and also on "not in current sprint". 

I have tried this as a formula but it is not working my user stories are filtered well :

What do you think is my formula wrong are is there something in my user story wrong ? I don't understand why it doesn't work... 

Could you help me with that ? 

[Tessa Tuteleers]

Hi @Manon Ledda , 

you JQL seems to be okay. You say 

 have tried this as a formula but it is not working my user stories are filtered well

What is the problem exactly? Are stories not in the right filter? 
Please show us your sprints / issues in sprints / results of the filter so we can advice more precisely! 

Cheers, 

Tessa

[Manon Ledda]

Hi Tessa ! 

The problem is that stories don't appear when I select the filter and if if some appear it is not 100% accurate... 
And I can't solve the problem... 

Here some pictures of the board I want to filter, one of a tickets :

[Tessa Tuteleers]

Hi @Manon Ledda , 

could you show us your sprint overview (backlog), as I don't see sprint information on your tickets themselves. 

Please note as well that a scrum board always shows the current sprint only, and all future sprints / backlog are not shown on the board, but in the backlog. 

[Manon Ledda]

Hi @Tessa Tuteleers ,

Thank you to take the time to help me, here is the photo of the backlog I don't know if it helps you...  :

[Kit Friend]

sprint in (openSprints())

and

sprint not in (openSprints())

---

Should sort you ^ 

[Manon Ledda]

It is still not working... :/ 

Thanks for the help

[Kit Friend]

Before trying on the board, check in the search results things appear - can you try and post grabs?