Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to track tickets moved from/into project ?

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.

4 answers

You might not find it in the JQL. I know that it should be possible at least as JIRA still knows how to send you to the new issue key if you visit the old issue. Store in the DB perhaps? Change history tables?

It's definitely in the history, you can see the key change from ABC-123 to XYZ-456, but no, there's no "was" function for project unfortunately.

Thanks, I see that it is not possible to do it using JQL. Does someone had a chance to solve this problem using direct access to MySQL ? Since "change project moment" is in the history , it should be possible to extract it .

I'd avoid reading the database - there's good reasons it's abstracted. But if you happened to read the tables changeitem (for the record "key") and changegroup (for issue id, author, and date/time) you'll find what you need.

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 ?

movedIssues() and recentProjects() functions.

0 votes

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.

Suggest an answer

Log in or Sign up to answer

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you