Advanced search : Display the current and next sprint

[Guillaume BORYCKI]

Hi the community, this is my first question here so thank you to those who will be able to answer my question :) 

I am building a project dashboard and I would like to display some lists of "JIRAs" which are : 

1. Planned in the current sprint
2. Planned in the sprint +1 
3. Planned in the sprint +2

If I use "sprint = XXX" in the search then, the dashboard remains static. I would like to make it "dynamic" following the life of the project without changing manually the sprint value in the searchbar every two weeks. 

Thank you very much for your help!

[Guillaume BORYCKI]

Hi all, 

I've found the way to answer to my 1st question "Display the current sprint". I use the following function : 

Sprint in openSprints() AND NOT Sprint in futureSprints()

And it works ! 

Now I still need to display (dynamically) the list of requests that are already planned in the next sprint (Sprint +1) and the sprint after (Sprint +2)

Thanks in advance for your help :)