JQL Filter for issues from actual Sprint

[Tommy Sete]

 Hello all,

my problem is a bit more complicated:
We have a dev team with their own sprints. But sometimes we need to test tickets in our project and then we create tickets and link them to the stories. But now I want to build a dashboard for us (testteam) with the tickets from the current sprint. But I am not allowed to assign the test tickets to the current sprint from the devs.

Approaches:
I tried to label the tickets, e.g. Sprint100 etc. but I fail because I don't want to manually increase the Sprint number in the filter. This should be automatic.

My second approach was to use duedate >= startOfDay(-14) AND duedate <= startOfDay() but It still takes tickets from the previous sprints (Depending on which day I look on the dashboard). Do you guys have any tips?

[Tommy Sete]

Hello and thank you for your answer. It's about tickets that are not assigned to a sprint but only have the label e.g. Sprint100. This must remain the same. But I can't put in the filter something like "show me the label with the highest number".

[Piotr Zadrożny _Eyzee_]

Well - you can use jira automation or other scripted solution to modify filters every one or two weeks to change labels to next number but probably it's not what you really want. I understand that you marked some issues with "Sprint100" label. Can you explain which issues have you marked? It's possible you don't need this label at all and you can accomplish your goal with another JQL query.

[Tommy Sete]

Unfortunately, I can not install addons. Again for clarification

Dev Team starts a sprint. There are tickets for new developments in the current sprint.

Test team (we) create test tickets which we then link to tickets in current dev sprint. We use Life Cycle for the tests. I would now like to have a dashboard based that I only show the tickets that are linked to the current sprint from the dev. But I am not allowed to install any automation or addons.

[Piotr Zadrożny _Eyzee_]

Hi @Tommy Sete 

Welcome to Community!

I am not sure if I understand you correctly.

If you wish to find all issues from project TEST in the current sprint you can use:

Sprint in openSprints() AND project = TEST

If you wish to find all issues linked to issues from project TEST in the current sprint you can use (it requires Scriptrunner addon to be installed on your instance):

issueFunction in linkedIssuesOf("Sprint in openSprints() AND project = TEST")

Kind

Piotr