You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.