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?
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?
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.store();// this is essential or the timestamp could not be stored.
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.
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:
Thanks for your detailed description about how to operate the database, I will have a try.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG