You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Jira isn't a time machine, but some functionality can turn you back to the past. You can use JQL queries to get a list of issues based on the value of those fields at a specific date in the past rather than the current value. It will be handy if you need to track what happened some time ago.
For example, issues updated last month/year or issues edited by a specific user for some past dates.
As not all searches are possible with JQL, you will also find a bonus solution to search history.
There are several options you can use to search history with JQL.
Advanced JQL allows getting changes only for some fields, which includes:
Example 1. Get the list of issues whose status was Done on a particular day for the DEV project.
Project = Development AND Status was Done ON "2022-04-22"
Example 2. Get the list of issues where status was Done for some assignee during last year.
status WAS Done and assignee WAS Jack DURING ("2020/01/01","2021/01/01")
Example 3. Get the list of issues where status changed from In Progress to Done before some date.
status CHANGED FROM "In Progress" TO "Done" AFTER "2022-01-01"
If you need to find the issues updated by a particular user, try updatedBy() function. Updates will include any issue field’s changes, creating an issue, creating/editing/deleting a comment.
Example 4. Get the list of issues updated by some user during the past two weeks.
issuekey IN updatedBy("Jack", "-2w"))
If you’re looking for issues or tickets that were created/updated/resolved within some time, follow the next cases.
Example 5. Get the list of issues created on 25th April 2022 before 2:00 pm for Development and Marketing projects.
Project in (Development, Marketing) and created > "2022/04/25" and created < "2022/04/25 14:00"
Example 6. Get the list of issues resolved on 25th April 2022.
resolved > "2022/04/25" and resolved < "2022/04/25"
What if you need to search for other past changes that JQL doesn’t support? It can be sprints, issue types, descriptions, comments, due dates, or other updates. Issue History for Jira can help here. The plugin is developed as a history journal for all past activities on the issue level.
To get an easier representation of what was changed there are strikethrough text and green and red highlights for additions and modifications. The report is easily filtered by assignee, project, sprint, label, date ranges, etc.
Example 7. Get the list of issues for the specific assignee with due date changes for the current week.
Example 8. Find out if there were any comments added to tickets for a support project within the last two days.
Example 9. What sprints were the issues taken through?
Example 10. Get the report with issue type changes.
Also, there is an additional option to search with the JQL with the Issue History.
Hopefully, the use cases above will help you get the data you need. You can try to search history with two options:
You are welcome to share the problem you’re trying to solve and ask for Community help in the comments below.