I have a project and I need to track which tickets are moved out of it during the week for example.
There is no 'was in' operator for PROJECT field.
The same question is how to track tickets which currently have my project but had another one week ago.
I spend a lot of time looking for this functionality in JQL.
Thanks for any help.
I took a look into the DB , looks like it is possible to get this info using tricky, having many JOINs SQL. There are 3 tables containing necessary data: changegroup, changeitem and jiraissue.
Still would like to avoid direct access to DB (thanks for comment Nic)
Does anyone had experience with this plugin https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin ?
movedIssues() and recentProjects() functions.
A possible solution is to set the initial status of a ticket created in the first project from "Backlog" to something specific like "Projectx backlog" by amending the workflow.
Then you can use the JQL: Status was "Projectx backlog".
In that way, whereever the ticket gets moved to, you can still identify the first Project the ticket was in.
Another way of doing this could be to use the JQL: reporter in membersOf("group")
That would allow you to see all tickets raised by members of a particular group.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event