JQL Filter Moved Tickets

[Patrick Decker]

Hi there, 

i´m despreately looking for a JQL Query that displays every ticket moved from the original project to any other. Is there anyone out there with an idea or maybe a resolution for my problem?

Regards,

Patrick

[Charlotte Santos -Appfire-]

Hi @Patrick Decker 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all issues that have been moved from one project to any other:

movedProjects in (ABC)

Or

movedProjects in (ABC, DEF)

Note: The query will find all issues which were in ABC or DEF at some point. Due to Jira plugin system limitation it is impossible to build a command which supports searching from/to.

Please contact our support if you have any other questions about this query.

We’ll be happy to help you! 😉

[Pavol Gočal]

Hello @Patrick Decker

I do not think that it is possible to accomplish this with JQL by default (maybe other community members will correct me and give you a direct solution).

What you can do is:

1. Create custom field (MoveIssue = true/false) and create automation (trigger by "Issue moved") that will set this custom field, when the issue is moved. Then you can use JQL to search for the issues, that have "MoveIssue" custom field set.
2. There's JQL Search Extension add-on, that has movedIssue extension. Although not sure, if it works also on cloud as the documentation reference server (not supported anymore) and data center.

[Pavol Gočal]

Hello,

you can check if resolution is set or a ticket is in specific status: 

resolution is not EMPTY and status in (Done, Resolved)