Is there a way to modify the create time of an issue

[xuhai zhao]

I want to change the create time of an issue through programming. I have found that the update and create operation of an issue both need the help of "IssueInputParametersImpl" class, but this class could not set the create/update time.

So is there a way to modify the create time of an issue through programming?

Thanks

[Vishnukumar Vasudevan [ACP-JA]]

You should edit the DB.

[Renjith Pillai]

I guess you can't.

I had seen a answer from Vishnu saying to edit the DB, but that answered has disappeared here. I guess that is the only option, but it can break JIRA if not done correctly. Search for the same in this site and you will get atleast 10 answers from @Nic warning about the same.

What is the usecase, can you explain it please?

[xuhai zhao]

Thank you for your concern.

There is a plugin that can copy an issue from a JIRA instance to another one. But the create time could not be copied. So I want to modified it.

I have used this way to achieve this function:

MutableIssue issue = getCreatedIssue();

issue.setCreated(getOriginalCreateTimeStamp());

issue.store();// this is essential or the timestamp could not be stored.

[Vishnukumar Vasudevan [ACP-JA]]

I too suggest to edit DB. My answer got deleted by mistake.

[Nic Brough [Adaptavist]]

If editing the database, you must - stop jira, get a backup, prove it works by restoring it and testing it on a dev/test system, run your SQL, start Jira, reindex and then I recommend the integrity checker too, just in case. Having said that, hacking a handful of create-dates is not going to be a huge risk, as it's a simple attribute.

Your code doesn't include reindexing though - I suspect that might be why your data is being seen as wrong.

[xuhai zhao]

Yes, just as you said, the copied Create Time has some small deviation: the date is right but the hour is not using this way:

"issue.setCreated(getOriginalCreateTimeStamp());

issue.store();"

Thanks for your detailed description about how to operate the database, I will have a try.