JQL to get latest stories transferred among squads

[Douglas Mendes]

Hello guys!

Could you give some ideas of how to get which stories where transferred among squads in -7d? 

Thanks!

[Piotr Bojko]

Try - https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview. You can use SQL then just like JQL:

select * from changes limit 10

[Douglas Mendes]

Hello Alexey, thanks for your help

I see. In fact we use differents projects under the same Jira instance as Squads. No custom field. The stories may be moved between all projects. Like this, is it possible?

[Alexey Matveev]

It depends on how you define if a story was transferred between squads. If there is a custom field called SQAUD, then it is impossible with JQL. Custom fields do not support historic JQL queries.

[Alexey Matveev]

It is also not possible. There is no JQL to find moved issues out of the box. You would need an add-on for it. For example, Jtricks plugin. There a JQL function called movedIssues:

https://www.j-tricks.com/jqlt-issue-functions.html

[Douglas Mendes]

Ok! Thanks again, mate!

Cheers

[Alexey Matveev]

You are very much welcome!