Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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?

Thanks.

2 answers

1 accepted

2 votes
Answer accepted
Jack Community Leader May 03, 2021

Try this...

project = IT and createddate >= startofyear() OR resolutiondate >= startofyear()

This is showing more data than needed, its pulling data for other projects as well.

Jack Community Leader May 03, 2021

Sorry left off some parentheses.

project = IT and (createddate >= startofyear() OR resolutiondate >= startofyear())

Thanks but this is still showing tickets that are created in 2018 and are in Closed state. Can you pls advise?

Here is my criteria, we only want to see the tickets that are created in 2021 and the ones that are open(not resolved) prior to 2021.

Jack Community Leader May 03, 2021

Do you mean by the ones that are open prior to 2021? Do you mean to say any issue that was created prior to 2021 that are still in an open state? Sorry I’m just not quite following what you’re looking for here

yes, all the tickets created in 2021 plus anything that is open from the time the project was created. Apologies for the confusion.

Jack Community Leader May 03, 2021

Maybe this then

project = IT and (createddate >= startofyear() OR statuscategory != done)

that JQL should give you all issues for project IT created this year regardless of the status and any issues created before 2021 that are not yet resolved. 

This worked like a charm! Thank you so much!

Could you also help me with another query, pls?

all the tickets created in 2021 plus anything that is open and created in 2020?

Thanks in advance.

@JackUpon looking closely, this is pulling the tickets that are fixed as well, is this because we are using too many resolutions and too many transitions? Is there a way to tailor this? pls. Thanks

Jack Community Leader May 04, 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. 

0 votes

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.

 

Thanks,

Anvesh

@KAGITHALA BABU ANVESHThis is pulling tickets that are Completed as well(Resolution is Fixed). can you help?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you