Hello Team, Can one of you help on writing the advanced JQL for the below requirement, please?
In Project IT all the tickets that are not Resolved(tickets that are in Open and In-Progress) before 2021 plus ALL the tickets that are created in 2021?
Are the ones in the fixed status created in 2021 or prior? Above JQL returns everything in 2021 regardless of status. So if the fixed issues were created in 2021 and that would be consistent with the JQL. However if they were created prior to 2021 and that tells me that your fixed status does not equate to a done status category.
Hi @Teza Jonnalagadda ,
For "all the tickets created in 2021 plus anything that is open and created in 2020?"
project = "IT" AND (createdDate >= startofyear('-1') and statuscategory != done) ORDER BY created ASC, updated DESC
Please check this.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events