How can i select issue statuses(text) from database?

Question

Hi,

please, how can I select status labels of issues over time? I need to select all statuses of all issues over time.

Right now I am using this select:

SELECt distinct
 issuestatus.pname as 'Status Label' --this is what I need reapair
 ,OS_HISTORYSTEP.STEP_ID 
 ,OS_HISTORYSTEP.START_DATE
 ,OS_HISTORYSTEP.FINISH_DATE
 ,jiraissue.ID
 ,cwd_user.display_name
 ,jiraissue.project
 FROM [jirasw7_prod].[jiraschema].[OS_HISTORYSTEP]
  inner join jirasw7_prod.jiraschema.jiraissue on OS_HISTORYSTEP.ENTRY_ID=jiraissue.WORKFLOW_ID
  left join jirasw7_prod.jiraschema.issuestatus on OS_HISTORYSTEP.STEP_ID=issuestatus.SEQUENCE
  left join jirasw7_prod.jiraschema.cwd_user on OS_HISTORYSTEP.CALLER=cwd_user.lower_user_name
 order by OS_HISTORYSTEP.START_DATE desc

The problem is that I can not set Status label, because I do not know, where is information about which Forkflow scheme issues use.

This select should be something like process log. :-(

Thank you very much for help!

Martin Rýznar · Answer

Isn´t there any way how to select string statuses based on the project and issue´s workflow scheme? :-(

Martin Rýznar · Answer

Yeah, there are Strings of statuses, but there is no way how to connect it with my result set. :-(

Roman Kersky · Answer

HI. Please try using the tables : [changeitem] and [changegroup]