Update transition date(s)

Esther Strom

We recently made some workflow changes that have resulted in odd transition dates. Because we're using a plugin that relies on the final transition date as the "done date" (Actionable Agile Analytics), those numbers are skewed.

I know that transition dates are gettable, as many plugins are able to display the date of specific transitions, but is there any way to update them? I'm guessing not because it would allow people to fudge numbers.

I know it's a bad idea; I just need to know if it's possible so I can tell my users yes or no. I'm good with using API's, and we have ScriptRunner as well if that helps.

Emre Toptancı [OBSS]

On the Server or DC platform, you can manipulate the data in your Jira database (namely changegroupitem table) to update those dates. Of course, this is a not-recommended approach and you should be careful about data consistency.

On the cloud platform, you don't have direct access to the database so updating dates in the DB table is not possible. Jira Cloud REST API also doesn't give you the option to update issue histories so that is also a dead end.

The only possible crazy way I can think of is using External System Import. External System Import (json import in particular) allows you to import issues with their complete histories. Exporting your existing issues with their histories and converting them to an importable json will be a nightmare but if you can do that, it should technically be possible to manipulate the json in the desired way, delete existing issues from your system, and import them again from json.

Your issue keys will change and many other traceability links might be lost so most people won't consider this as an option. I know I wouldn't, unless I absolutely had to.