Setting issue created date with scriptrunner Edited

I am trying to change created date for an old issue using the Adaptavist scriptrunner console. I have been abnle to change summary but changes to date created don't seem to save. This is my script:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import java.util.Calendar
import com.atlassian.jira.event.type.EventDispatchOption

MutableIssue issue = ComponentAccessor.getIssueManager().getIssueByKeyIgnoreCase('ABC-12')

Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.MONTH, 7);
calendar.set(Calendar.DAY_OF_MONTH, 10);

issue.setCreated(new java.sql.Timestamp(calendar.getTimeInMillis()))
ComponentAccessor.getIssueManager().updateIssue(ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser(), issue,EventDispatchOption.ISSUE_UPDATED, false)

Should this be possible or ir there another way to do it?



2 answers


I don't this is going to work. I've tried it but it doesn't work that way. 

As an alternate approach you can alter the value in database.
That would work fine. But why would you need to change the created date anyway.
You would need to be cautious about it. 

Thanks for the reply. I can understand why it wouldn't work :(

I want to send an export of some issues to a customer, and forgot  to enter an issue until today even though it was fixed ages ago. It would look much neater to the customer if the created date was correct.

Well in that case if it is just one single issue. 
you can find that issue in database and update its created date.
You can use the following queires:

To get the issue (we need id from here)

Select id, created 
from jiraissue
where project = 1234 and issuenum = 123;

Issuenum is the actual number of the issue, for e.g. the issue key is Test_Proj-123, then the issuenum is 123.
Project is the projectid. (get it from the admin -> detail) at the end of url. 

Assume we get id = 10101

Then update the issue

update jiraissue 
set CREATED = '2017-09-04 16:17:49'
where id = 10101

 That wil update the created date of said issue to sept 4th and to the according time.


Hope this helps.

Why don't you simply try project import wizard? This has an ability to update multiple issues' created datetime in one go without any problem.

For that, you can create a CSV file including details like key, created and summary.

key created summary
SR-545520/02/17 00:00test 1
SR-567117/03/17 00:00test2 
SR-56725/4/2017 0:00test 3
SR-56731/3/2017 0:00test 4
SR-56749/3/2017 0:00test 5

Just make sure that key and summary are as per the issue.



Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,223 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you