Issue Statuses with (No Category) are auto-generated by Jira Service Management
Platform Notice: Server, Data Center, and Cloud By Request - This article was written for the Atlassian server and data center platforms but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.
There are some issue statuses: (Waiting for support) & (Waiting for customer) that auto-generated by Jira Service Management are categorized with a "No Category". The "No Category" is not allowed in normal Jira usage where all statues are required to be categorized into:
- To Do
- In Progress
If the statues is changed to either three of the categories above, the category will not be able to change back to "No Category".
This is just the Jira Service Management created the statuses without the requirement, it will not cause any further issues other than changing the color of some status lozenges.
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- Backup your Jira database so that you can rollback if you encountered any problems.
- Stop Jira.
Run the SQL query below in your database to modify the intended status category to "No Category":
UPDATE issuestatus SET statuscategory = 1 WHERE pname = 'STATUS_NAME';
Just change the STATUS_NAME to the status name that you wanted to change.
- Start Jira.