I need to export all the tickets from my service desk project. How can I generate such a report.
Hi @cHurley
You can do this via issue search:
Note: You can only export 1,000 issues at a time.
---
In terms of tickets from the last year, JQL which might work depends on the need - for example...
Created within 2024:
created >= startOfYear()
Created within a year:
created >= -365d
...etc
If you need specific help with the search query, let us know some more details!
Ste
@cHurley you can use filters to get the information you need. If you need to to export the data you can creak the filter and the export the results to excel. You will be limited to 1000 issues per export. https://support.atlassian.com/jira-software-cloud/docs/manage-filters/ You can also just look at the results on the filter.
JSM also allows you create a custom report to see information as well. https://support.atlassian.com/jira-service-management-cloud/docs/what-are-custom-reports/
@cHurley -
You can use the following JQL -
project = <your project key> and created >= startOfYear(-1) and created <= startOfYear() order by created asc
Here is how to export the resultset when issues returned based on your JQL is over 1000+ rows - https://confluence.atlassian.com/jirakb/export-over-1000-results-to-excel-from-jira-cloud-779160833.html
Hope this also helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Technology Applications Team
Viasat Inc.
Thank you all for the tips and advice and sorry for not replying earlier.
Here for anyone else were the commands I ran
First attempt only showed me 6 monthsproject = [its name] AND created >= startOfYear(-1) AND created <= endOfYear(-1)
so had to change the command to get the remainderproject = [its name] AND created >= startOfYear(-1) AND created <= endOfYear(-18M)
It looks like you're new here. Sign in or register to get started.
