How to write a filter to list out the Last Quarter issues

ganesh417ece October 12, 2022

How to write a filter to list out the Last Quarter issues

2 comments

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 12, 2022

You can't create a "last quarter" but you can create filters for each quarter. For example, assuming you want to find issues created in Q3...

createdDate >= startOfYear(6M) AND createdDate <= startOfYear(9M) ORDER BY created ASC

Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 12, 2022

Hi @ganesh417ece ,

Welcome to the community !!

There is no direct keyword to get Issues from Quarter. You need to use Dates like below in JQL filters

created >= '2022-01-01' AND created <= '2022-04-01'
dates should be mentioned in yyyy-mm-dd format 

Please note: created <= '2022-04-01' will get all tickets created before 2022-April-01 00:00Hrs

If you need to mention hours, please use example created <= '2022-10-12 11:00' 

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 12, 2022

For this use case I like to avoid using specific dates since they don't extend to the next year without having to edit, changing "2022" to "2023" for example. Rather I favor "startofyear()".

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events