How yo join issue status in a query?

[Juan Velandia]

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!

[Randy Ho]

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]

Thanks Randy. I will give it a look

[Max Foerster _Decadis AG_]

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]

Thanks Mate. I will give it a look

[Peter DeWitt]

@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

[Juan Velandia]

Thanks Guys. I will give it a look