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

Snapshot of jira issues statuses on the specific date

Is it possible to get snapshot of jira issues statuses on the specific date? For example, I want to get statuses of issues for my project on 27th of January. It seems that it is not possible to do this with JQL. Are there any other approaches?

2 answers

1 accepted

5 votes
Answer accepted

To make use of plain JIRA:

Make a couple of filters for your status, and add one "Issue Statistics' gadget per filter in a dashboard (say using Project Name as the criteria). So you will get count of one status per gadget.

status WAS "Open" DURING ("2013/01/27","2013/01/27")

There can be a small issue as those issues which got transitioned during that day will appear in multiple statuses (so pickup a holiday to avoid that situation, which is true in this case)

We dont want to be specific about the status. It can be any status. Is there a way to do it with standard JQL or is there any point in time reporting available ?

try this:

AND status was in (***add all relevant statuses you have***)  ON ('YYYY/MM/DD')

Won't this still show the current status of the ticket though? Not the status of the ticket on that date.

For the actual tickets statue you are correct - JIRA is dynamic and there for will present the current status.

but JQL result is all tickets that where on the status you searched on this specific date.

JQL should run per status 

air455 I'm New Here Dec 10, 2020

The above query will list the ticket that has the specific status on a specific date. However, if the status of the ticket got changed several times on the date then that ticket will meet the criteria for several status.

 

If I only want to find the tickets that has DONE status as the "last status" for the specific date, how should I write the query?

did you figure it out @air455  ? looking at the same here. cheers

@air455 @Michal Gasparovic  
add to the JQL - 

AND Current status in <status u want>

so jql should be:
Project in (PROJECT) AND status was in (STATUS) ON ('YYYY/MM/DD') and status in (STATUS)

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