Forums

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

How yo join issue status in a query?

Juan Velandia November 21, 2019

Hello, Newbie Question:

 

I would like to group different issues status in thre categories, for instance: 

New:

- NEW TO COMPLETE
- TAKEN INTO ACCOUNT 

In Progress

- NEED MORE INFORMATION
- PENDING
- TO BE TESTED
- IN PROGRESS

Done
- REFUSED
- VALIDATED
- VALIDATION IN PROGRESS

Do you think this is possible. Thanks in advance!

 

4 answers

0 votes
Juan Velandia November 21, 2019

Thanks Guys. I will give it a look

0 votes
Peter DeWitt
Community Champion
November 21, 2019

@Juan Velandia , In cloud, navigate to Jira Settings -> Issues -> Statuses. When you edit a status or create a new one, there will be a drop down in the middle of the dialog box that allow you to select the Status Category. 

As far as creating new or modifying existing Status category, I don't believe this is possible.

-pjd

0 votes
Max Foerster - K15t
Community Champion
November 21, 2019

Hey Juan,

I'm not totally sure what you're trying to achieve here. So what kind of JQL query are you trying to build? Or where do you want to group the statuses?

Or do you want to group the returned issues by status category? That would be possible using "ORDER BY statusCategory" in your query.

Best, Max

Juan Velandia November 21, 2019

Thanks Mate. I will give it a look

0 votes
Randy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 21, 2019

You can do this at the system level but it will apply to the status's globally.

 

There is a statusCategory you can assign each status.  Set them to Todo, In progress, and Done. 

 

Then when you query, you can key off these categories using the statusCategory field:

e.g. `statusCategory=Done`

Juan Velandia November 21, 2019

Thanks Randy. I will give it a look

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events