Custom fields fill in automatically

[Robert Czapor]

I would like to add custom field 'Date time' in that way that this field will be updated atuomatically, how to do that?

[Cyril Egan]

You'll need the Jira Misc Workflow Extensions plugin

Use the Copy Value From Field to Field post function

Steps

1. Create a custom field to store your data/time in and configure for your needs.
2. In your workflow add a post function to copy the "Updated" field (the timestamp of when an issue was last updated) into the custom field.
3. Move the post function below the "Update change history for an issue and store the issue in the database." step.
4. Export your data to excel and use the "DAYS360" formula function to calculate the number of days between 2 dates.

[Robert Czapor]

Thanks Cyril! It looks that is what I need but when I tried to do exactly what you described I had found some problems.

I've added 'Data Time' custom field with configuration:

-bug

-applied to my project

Copy Value From... post function I've added to start progress action. Issue in state Open I've changed to In Progress but when I used filters for all issues column Data Time is empty. Any ideas where I've made mistake?

[Nic Brough -Adaptavist-]

The answer is almost certainly "write code".

I can't really tell you much more than than because "update automatically" doesn't tell us what you actually need, so I can't point you at anything that might already do it, and I can't recommend any specific thing to look at or think about. (e.g. writing a derived field or populating a fixed field are two core options, but I can't even begin to think about which might be better, let alone how to do them)

[Robert Czapor]

Ok, what I need is get how much time issue spend in each steps. When issue was set to INPROGRESS, RESOLVED etc. So I tried to add field for collecting dates. I do not know how to (or it is possible) configure this field in that way that date won't be set by user but automatically by Jira?

I would like to get this dates using filtres and export it to excel report.

[Nic Brough -Adaptavist-]

Ok, well, I've nothing to add to Cyril's answer - it's exactly what I've done. Add one or more custom date/time fields and update them in post-functions.

You might want to have a quick look at the "time in status" field that's built into Jira though. On it's own, it doesn't do much, but it does enable some reporting on time issues spend in certain status - you might find that useful too.