any jql query which will help generate report for stories being moved over sprints (more than 2)

[Krishna Mantha]

Hello, 

I was trying to generate a reprot in which i can see the list of stories which are moved over to sprints various times . (say more  than 2 sprints). 

Did any one try jql query for this. 

Thank you.

[Trudy P Claspill · Accepted solution]

Hello @Krishna Mantha 

There is not a native function that you can use in JQL for your requirement.

However, @Bill Sheboy presented a solution that uses an Automation Rule and an Entity Property in an answer on this post:

https://community.atlassian.com/t5/Jira-questions/JQL-query-to-find-issues-in-multiple-closed-sprints-without/qaq-p/2402571

[Krishna Mantha]

Thank you. I used the query a while ago and it did help.