I am trying to find the previous all status of tickets so that i can extract them in excel and check with pivot table about most used and unused status. But JQL filter only showing single record per issue.
below is jql
project = ''
AND status was in (Open) AND status was in (SHAPING) AND status was in (CLOSED) during (startOfMonth(-1), endOfMonth(-1))
can you please help me to find a way to extract status used and how i can display multiple tickets. Note: I am trying to avoid any paid plugin here
Thank you for your response. Yes that's correct JQL finding 1 result only. actually, i am trying to find the previous status of the tickets to check what all statuses are used by different tickets
Example ABC-001 past status was NEW, OPEN, and CLOSED so i am looking for a filter something like which can show me past status and timing in each status. That will help me to understand the time in status for each ticket
project = 'ABC' AND STAUS WAS IN(NEW, OPEN, CLOSED)
It should display 3 records with dates
I have researched that there are lots of plugin available and mostly paid so trying to find out a way to extract report and use the PIVOT table to generate data.
JQL is for finding issues, not field data. Your search is returning one line because there is only one issue matching the question. If you translate the JQL back into English, it is "show me a list of issues from project ABC that have been in a status or New, Open or Closed". It's not going to give you the same issue several times, by the very definition of "search for issues" it should not.
You will need to look for a "time in status" type report. Searching is not the right function to be looking at for your report.
Project managers know this problem: A “mountain of work” lays in front of you, and you don’t know how and where to tackle them. Different to-dos lie ahead, but just one task after the other can be ha...
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