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

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?


3 answers

You should edit the DB.

0 votes
Renjith Pillai Community Champion Aug 14, 2012

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.setCreated(getOriginalCreateTimeStamp());;// this is essential or the timestamp could not be stored.

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

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.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,979 views 12 18
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot