Setting issue created date with scriptrunner

[anorakgirl]

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.setTimeZone(TimeZone.getTimeZone("Europe/London"))
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?

Thanks!

[Tayyab Bashir]

Hi, 

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. 

[anorakgirl]

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.

[Tayyab Bashir]

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.

[Maitrey Patel]

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-5455	20/02/17 00:00	test 1
SR-5671	17/03/17 00:00	test2
SR-5672	5/4/2017 0:00	test 3
SR-5673	1/3/2017 0:00	test 4
SR-5674	9/3/2017 0:00	test 5

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

Cheers,
Maitrey