Report

[Timothy McKay]

I need to create a report that shows me all of the tickets, all statuses for 2025. Does anyone know how to create this

[Mariia_Domska_SaaSJet]

Hi, @Timothy McKay 

You can use the JQL query: (created >= 2025-01-01 AND created <= 2025-12-31) OR (updated >= 2025-01-01 AND updated <= 2025-12-31) and save the filter. If you want to display the results on your dashboard, use the “Filter Results” gadget.

Or do you need something more custom?

[Aaron Pavez _ServiceRocket_]

Hi @Timothy McKay 

>that shows me all of the tickets - for 2025

JQL selecting starting data jan 01 2025 and final date dec 31 2025. you can make it global or select a single project.

> all statuses for 2025

JQL will show the current ticket status. 

project = "projecthere" and createdDate >= startOfYear() and createdDate <= endOfYear()

Then, you just add columns to show the fields you want to see. Then you can export.

Does this work?

Regards - Aaron