How can I make a query to get all the tickets created during the last 3 months?

[Alvaro Hernandez]

Hello!

I'm trying to make a query with JQL to get all the tickets created and updated during the last 3 months but with the query I'm showing here I can only get the tickets created during the month of November 2024.

Can you show me how to do it? What is wrong?

project = "HelpDesk” AND (created >= startOfMonth(-3M) and created <= endOfMonth(-3M)) AND updated <= endOfMonth(-3M) order by created ASC

[Gerusa Lobo _e-Core_ · Accepted solution]

Hello @Alvaro Hernandez

The jql could be:

project = "HelpDesk” AND (created >= startOfMonth(-3) and created <= endOfMonth(-1)) AND (updated >= startOfMonth(-3) and updated <= endOfMonth(-1))order by created ASC

For issues of the created of the last 3 months from december to february, you could use:

created >= startOfMonth(-2) and created <= endOfMonth()

If you want the 3 last full months, from november to january, maybe you should use:

created >= startOfMonth(-3) and created <= endOfMonth(-1)

If you want only issues created and updated use 'and', and if you want issues created or updated in this period, use 'or'

I hope help you.

[Alvaro Hernandez]

Thank you @Gerusa Lobo _e-Core_ !

Your advise are very usefull to me

[Rebekka Heilmann _viadee_]

Hi @Alvaro Hernandez 

can you specify what timeframe you want to cover?

Do you want to include all issues that are 3 months old or newer to the day? 04.11.2024 - 04.02.2025
Or only the issues that have been created in the previous three months? 01.11.2024-31.01.2025

Or something else entirely? ;)

[Alvaro Hernandez]

Hi @Rebekka Heilmann _viadee_ 

I need to get all tickets from November 2024 to January 2025.

[Rebekka Heilmann _viadee_]

In that case @Gerusa Lobo _e-Core_ gave you the answer already :)