Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

How to display duplicates in JQL query


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

1 answer

1 accepted

5 votes
Answer accepted

JQL will display multiple issues when the question returns multiple different issues.

It sounds to me like your query is only finding one issue to report on, is that correct?

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


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.

Like # people like this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Staying organized with Jira: best practices for a better project management

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...

233 views 2 1
Read article

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