Hi, We are building a datamart with all the issues and their status history, including elapsed time in each status. We are having issues aligning the status history on the web interface with the result from the database query. Our query is as follows (which I adapted from the forum). select prj.pname as project , ji.issuenum as issuenum , isc.pname as issue_status , ji.workflow_id , osh.id as history_status_id , osh.action_id as history_actionid , osh.start_date as history_start_date , osh.finish_date as history_finish_date , osh.status as history_status , osh.caller as history_user , osh.finish_date - osh.start_date as elapsedtime from jiraissue ji , os_historystep osh , os_currentstep osc , project prj , issuestatus isc where ji.workflow_id = osc.entry_id and osc.entry_id = osh.entry_id and ji.project = prj.id and osh.step_id = isc.sequence AND JI.project = '15602'Below are the result from the query which clearly shows a different status from the UI transition tab.What could I be missing? Thanks for the kind help. ORDER BY ISSUENUM DESC;ETFI-2204.PNGETFI-2204_SQL.PNG

Community
Q&A
Jira
Questions
Get Issue Status History into Data mart

upgrade

while upgrading our Jira Application from Version 8.20.5 to 8.20.8 we encountered some issues

Firstly, it showed an Application was being used when the services was stopped.
The second error that we received was "The directory you have selected is not a JIRA Core installation directory”

please advice the solution for recommend which version is best

2 answers

1 accepted

0 votes

Answer accepted

Because you analise workflow itself, but you need to investigate change history. Here is an example how to get all change histories for all issues in JIRA:

Select
	jiraissue.*
	, changegroup.*
	, changeitem.*
from
	jiraissue
	join changegroup	
		join changeitem	on	changegroup.ID = changeitem.groupid
	on jiraissue.ID = changegroup.issueid

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi Vasilliy,

Fantastic! It did work and I am getting the output we expect.

Thank you for your help.

Best Regards

Erwin

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

upgrade

2 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events