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

Question

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 ?

Perry Tancredi_q81b1l · Answer

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 (?)

Thomas Magny-Garcia · Answer

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!

Nir Haimov · Answer

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