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?

[Stephen_Lugton]

Hi @Timothy McKay 

The answers already given will give you any work items that were created or updated this year, but will not give you any work items that were created before the start of the year and were not Done at the start of the year and which haven't been updated this year.

If you want that, try this one:

project = YourProject AND (created >= "2025/01/01" OR status WAS NOT IN (Done, Rejected) ON "2025/01/01") AND updated <= "2025/12/31"

[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