Accessing transition dates in JIRA

[Guilherme Peres]

Hi,

I'm trying to populate a date custom field in JIRA through a groovy script using a date from a previous transition. I was trying to avoid SQL queries (even knowing that OS_HISTORYSTEP has the values that I want, specifically FINISH_DATE), and thought that ChangeHistoryManager would have what I need, but I don't see any methods to get the STEP_ID or ACTION_ID from ChangeHistories or ChangeItems. Since these are the ones I need for identifying my transition, is there any way to get them besides SQL? Or is there an easier way to do what I want?

(manually is not an option: there are 3000 issues in need of this)

Thank you!

Guilherme

[Deleted user · Accepted solution]

Of course the are values you are looking for - look for changes of field status.

Have a look at TransitionsManager.java from JIRA Suite Utilities - although written rather obsolete way...

[Guilherme Peres]

Well, that was pretty straightforward. Sometimes I forget that status is also a field...

Thank you very much!