nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fetch closed date of old tickets and retrospectively populate field

Ray S

I am trying to find a way to fetch the last-known closed date of a ticket and retrospectively populate a 'closed date' field so that I can calculate how many days a ticket was open in throughout it's whole lifespan.

I need to be able to add the data column as part of my filter results. Ideal solution:

issuetype | key | summary | created | date closed

Note: We are not able to install random plug-ins but we do have access to Script Runner

Accepted answers

Kian Stack Mumo Systems

Ray,

Can you use the existing system field of "Resolution Date"? This marks when a ticket was resolved, which is when Jira considers a ticket to be closed/complete.

Thanks,

Kian

All comments

Kian Stack Mumo Systems

Ray,

Can you use the existing system field of "Resolution Date"? This marks when a ticket was resolved, which is when Jira considers a ticket to be closed/complete.

Thanks,

Kian

Ray S

I have 'resolution' field which shows me the status (withdrawn, unresolved etc) but don't seem to have 'resolution date' option when I type in the columns pop up

Kian Stack Mumo Systems

In the columns, the field I'm referring to is called "Resolved". Let me know if you're able to find that!

Ray S

Perfect, exactly what I was looking for! Thanks very much

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

post-function