I'd like to get a local copy of all the stories I have completed in the last year. Does anyone have an idea?
Hi Tim,
A saved search plus the export button does this.
type = Story AND (assignee = currentUser() OR assignee WAS currentUser()) AND statusCategory = Done AND resolved >= -365d ORDER BY resolved DESC
the WAS part also finds stories that were assigned to you and later handed to someone else, for example to QA before closing.
i wouldn’t clone the stories. A clone is a new work item inside the same Jira, so you still don’t have a local copy. Each clone counts as a newly created work item, so it can fire any automation rules your team has on “Work item created”. You’d also add a pile of duplicate stories that can show up on boards and in reports. On top of that, Jira Cloud has no bulk clone yet (JRACLOUD-37520), so you’d be cloning a year of stories one at a time. Exporting doesn’t change any data in Jira, and you get a file you can keep locally.
Are you on Jira Cloud? And does “worked on” mean assigned to you, or stories you logged time on?
Hi @Tim Olvey
Welcome to the Atlassian Community!
You can follow steps shared by Pavel to download your completed stories
However, if you need a report specifically for 2025, and not for the past 12 months, you can use this query
Project = <your project> AND type = Story AND assignee = currentUser() AND statusCategory = Done AND resolved >= "2025-01-01" AND resolved <= "2025-12-31" ORDER BY resolved DESC
Cheers!
Hi @Tim Olvey,
If "worked on" is wider than being the assignee, you can widen Pavel's query:
type = Story AND statusCategory = Done AND resolved >= -365d AND (assignee WAS currentUser() OR status CHANGED BY currentUser() AFTER startOfDay(-365) OR worklogAuthor = currentUser()) ORDER BY resolved DESC
status CHANGED BY
worklogAuthor
If you mostly worked in sub-tasks under other people's stories, run it again with type in subTaskIssueTypes() in place of type = Story and add the Parent column to see which stories they belong to.
type in subTaskIssueTypes()
type = Story
Then Export > Export CSV (all fields) for the local copy.
I vote for this query as it implements the "most general" meaning of "worked on". As the original requester wanted a "copy" of each matching work item, exporting them to PDF may be a better option than exporting to CSV (less details, no formatting, etc.).
You can do this with a JQL search and a CSV export, no app needed.
issuetype = Story AND assignee WAS currentUser() AND resolved >= -365d ORDER BY resolved DESC
Assignee WAS also catches stories that were reassigned to someone else after you worked on them. If you prefer "stories where I changed the status", use:
issuetype = Story AND status CHANGED BY currentUser() AFTER -365d
Tip: save the query as a filter, so you can run it again next year in one click.
It looks like you're new here. Sign in or register to get started.