Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,456,057
Community Members
 
Community Events
176
Community Groups

How to display duplicates in JQL query

Hi 

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

2 answers

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

project = 'ABC' AND STAUS WAS IN(NEW, OPEN, CLOSED)

It should display 3 records with dates

ABC-001 NEW

ABC-001 OPEN

ABC-001 CLOSED

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
0 votes

@Anurag Sharma 

  1. First ask your team select duplicate as a resolution when they resolved ticket
  2. use this JQL: project = [YOUR_PROJECT] AND status=Resolved and resolution = Duplicate

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events