Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,431
Community Members
 
Community Events
165
Community Groups

Need help with JQL query to find out dates in a ticket - IN PROGRESS & DONE

I need help with a JQL query to find out 2 dates

 

  1. Date when a ticket was marked to UNDER WORK/ IN PROGRESS
  2. Date when a ticket was marked DONE

1 answer

1 accepted

2 votes
Answer accepted
Jack Brickey Community Leader Jun 08, 2022

Hi @Amitava Mallick ,

for #1 - OOTB JQL cannot find the dates when an issue entered a status as there is no field where this is recorded. For this to work you would need a field for each status and use Automation to record the date when the issue transitions. There are addon solutions that may work here and I suggest checking the Marketplace.

for #2 - you can use the Resolutiondate for this assuming you are setting the Resolution when an issue is marked as Done

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