Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need JQL query to output Resolved, Closed and Dev Complete as Done

C-Robert.Gill November 10, 2023

Need JQL query to output Resolved, Closed and Dev Complete as Done

1 answer

1 vote
Laurie Sciutti
Community Champion
November 10, 2023

Hello @C-Robert.Gill ~ If I understand correctly, you want to use statusCategory:

 

statusCategory = Done
C-Robert.Gill November 10, 2023

Hang on, I have multiple things happening in my query so I want see all New, In Progress, On Hold, Watch and was trying to keep the number of categories of what is ultimately Done, as done rather than have three more categories (Resolved, Closed, Dev Complete)

 

C-Robert.Gill November 10, 2023

  So rather than add percentage done here...
Screenshot 2023-11-10 104154.png

C-Robert.Gill November 10, 2023

project = [____] AND "Make and Model" = [_____] AND Type = Bug AND status not in (Cancelled) AND priority in ("Blocker/Emergency", "Critical/High", "Major/Medium") ORDER BY priority DESC, updated DESC

Laurie Sciutti
Community Champion
November 10, 2023

Ah.  You can't combine those in the Issue Statistics gadget, nor can you use the statusCategory statistic.  I checked the 2-dimensional gadget and that doesn't allow statusCategory either.  I'm not aware of any OOB that do that but I do know that there are plugins that do.  I use Custom Charts for Jira   HTH

Like C-Robert.Gill likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events