Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Dear Community,

I would like to find all issues in Jira which have changed status from "New" to "To Do" in the last 4 weeks. Unfortunately, the filter gives me all issues which have changes status from new to "to do" then "In Progress" and "done".

Here's my code

project = "XYZ" AND status changed from NEW to "TO DO" AFTER -4w AND component = "XYZ"

Please advise how to limit issues just to receive one status changed from new - to do only?

2 answers

1 accepted

0 votes
Answer accepted
Jack Community Leader Dec 07, 2020

Hi @Magdalena Migas , I'm not sure I understand your goal. Your JQL looks correct from what I was thinking your goal was so obviously I don't understand. You mention getting issues returned that are currently in states other than "To Do" so maybe you want to only show issues in "To Do"?

project = "XYZ" AND status = "TO DO" AND status changed from NEW to "TO DO" AFTER -4w AND component = "XYZ"

if not, please help be better understand.

Hi Jack ! 

Thats exactly what I was looking for ! 

Thank you :)

Like Sudarshan TS likes this
0 votes
Sudarshan TS Community Leader Dec 07, 2020

Can you try seeing this result using the control chart?
you would get the time each issue spent in the column, and indirectly obtain the number of issues.!

Though, I understand your question is to create a JQL. :) 

I just want to limit results issues just for one transition of status changed from new to "to do:

Sudarshan TS Community Leader Dec 07, 2020

yes, I get your need.!
lets wait for any other answers here.! :) 
I just gave you a Workaround, not exactly what you needed

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
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