Report

Question

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

Stephen.Lugton · Answer

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"

Mariia_Domska_SaaSJet · Answer

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_ · Answer

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