Trying to create a JQL or ScrpitRunner query to pull unassigned tickets from JSM within sprint

[Ranee]

Basically we are looking to create a ScriptRunner code or JQL that we do not have to manually change every sprint, that would output all of the tickets that were created within the current sprint at the time, that are not set to that or any sprint and are unassigned. Everything I am coming up with is a dead end or is requiring that we manually change the code or JQL every sprint to continue to get new results. We are also using JSM for the queue and connect them to the sprint which is on a Kanban board in another location in jira. All of this is on data center version 8.20.7

[PD Sheehan]

I think you have 2 competing criteria

"created within the current sprint"

and

"not set to that or any sprint"

How can you know the boundary of the sprint to search by creation date if the issue is not assigned to the sprint? Which sprint boundaries would need to be compared (most environments will have multiple sprints/boards)?

If your sprints are always 3 weeks long... could you try something like:

created > startOfWeek(-2) and sprint is empty

This should include all issues created in the current week plus those created in the previous 2 weeks and that are not assigned to any sprint.