OS_CURRENTSTEP AND OS_CURRENTSTEP_PREV RELATION

[krishnan]

How are the tables os_currentstep and os_currentstep_prev related?  How are the tables os_historystep and os_historystep_prev related?

Thanks

Krishnan

[Amit Kumar Sharma]

os_currentstep stores status of issue as of now. Its entry_id is same as workflow_id.

So in case if you update issue status in jiraissue table then you should update in os_currentstep table also.

UPDATE os_currentstep SET step_id = 6 where entry_id = (select

workflow_id from jiraissue where pkey = <put key>');

os_currentstep_prev stores previous id of issue id.

HTH.

Thanks

Amit