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

Alvaro Hernandez_abihvg

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

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.