Getting the mapping between Status and StatusCategory

[Richard George]

The problem I'm solving is to associate an employee and cost to tickets being worked per month. For example, if a ticket is moved from new to indeterminate and then to done over two days, then the cost of that employee for the two days is allocated to the ticket. 

I am using cloud Jira with multiple projects. Data processing is via the ETL functionality of Domo. 

I can use

project = GALACTICA AND status changed during("2019-07-01", "2019-07-31")

to get a list of all issues that changes state for July for the single project GALACTICA. What I need next is the list of status in GALACTICA and how that maps to the statusCategory. 

Is there anyway I can get this data either using a JQL statement?

Any help would be much appreciated.

Regards, Richard

[Earl McCutcheon]

Hi Richard,

There is not a direct method to get a list of statuses in a particular project other than looking at the workflow in the application front end, and comparing them to the statuses category mappings in the administration section, but as a workaround check out the following post that covers this question in more detail giving some API calls that can be used in combination to tie the info together, Noting the mentioned feature request in the second comment has been implemented stabilizing the endpoint with full details in the linked feature request:

• https://community.atlassian.com/t5/Jira-questions/How-to-get-all-Jira-statuses-from-a-workflow-of-an-issue-by/qaq-p/461172

Regards,
Earl