Where can we find the names for statusCategory in the jira database ?

[Neha Sharma]

Hi, 

The table dbo.issuestatus contains a column called statusCategoy which has numbers as values. Where can we find the name for the corresponding number values for the statusCategory ?

[Nir Haimov]

Hi,

i don't think it's exist in the database, but anyway, all you have are 3 options, not hard to remember:

2 = To Do

3 = Done

4 = In Progress

[Thomas Magny-Garcia]

Hi @Neha Sharma ,
In fact, there is a way to get this :

GET /rest/api/3/statuscategory

 For more information : https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-statuscategory-get

Hope it helps!

[Perry Tancredi]

Note that the names will differ depending on whether they're retrieved from the API or Webhook: https://jira.atlassian.com/browse/JRACLOUD-68855

API:

• To Do
• In Progress
• Done
• No Category

Webhook:

• New
• In Progress
• Complete
• Undefined (?)