How to search issues by their "first sprint occurrence"

Question

We are moving some issues from sprint to sprint because they are not closed by the customer yet. In order to keep a clean view it would be awesome to filter these issues by their "first sprint occurrence"

Example

Issue 1 -> Sprint 1, Sprint 2, Sprint 3
Issue 2 -> Sprint 2, Sprint 3
Issue 3 -> Sprint 3

Expected outcome when searching for
"Sprint 1" -> Issue 1
"Sprint 2" -> Issue 2
"Sprint3" -> Issue 3

Current result:

"Sprint 1" -> Issue 1
"Sprint 2" -> Issue 1, Issue 2
"Sprint3" -> Issue 1, Issue 2, Issue 3

I know the sprint report but in this specific case I need this as a JQL filter.

Any help is appreciated :)

Chris Lange_sisowi · Answer

For now I go with a manual workaround: just label all issues from a sprint accordingly. when they appear in a sprint for the first time. Then they can be found regardless in which sprints they are :)

Jack Brickey · Answer

@Chris Lange, this is an interesting UC and I could see it might be useful. However, AFAIK this cannot be done using OOTB JQL. It might be possible using a scripting addon e.g. Scriptrunner or Power Scripts.