You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
Hello!
Please tell where can I find a edited comment history?
I have used schema(https://developer.atlassian.com/server/jira/platform/attachments/jira-7-9-2-database-schema.pdf).
What table contain this infromation?
Comments do not have a history. If you edit a comment, the old one is destroyed, you can't know what it was in Jira.
There is an open improvement issue logged with Atlassian to provide a comment history, but generally, I just turn off "edit comment" permission on systems where the history matters.
@Nic Brough _Adaptavist_ Would you happen to have a link to the issue? Is it possible to vote on it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you mean the comments from before they were edited, they aren't saved. Just like when you delete issues you can't recover them. In the related content someone has a plugin that saves them. I don't allow deleting issues or comments. They are historical data that may have been acted upon and you would want to know what that data is.
Since you're new:
Do not delete issues. When you delete it is GONE. Hardly a week goes by without someone wanting to restore an issue. Deleting issues will come back and bite you when it is the most inconvenient. I suggest closing with a resolution value of Deleted anything you want to delete. I implement a special transition only the project lead can execute and it requires filling in a reason field from a select list (such as entered in error, OBE, Duplicate, Other) and explanation text.
Deleting issues destroys historical data. Missing issue numbers will eventually cause a question about what it was and why was it deleted even if it was done properly. Missing data always brings in the question of people hiding something that may have looked bad.
The only viable way to restore an issue is to create a new instance of JIRA and restore a backup that has the issues. Then export them to a csv file and import them to your production instance. You will lose the history.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Seems like sub-optimal behavior. Editing is not the same as Deleting. I am having issues today because a QA is after the fact editing their test case comments to cover cases that weren't actually covered.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is not great. There is a request logged to cover maintaining a history of comments, but at present, most Jira admins simply remove the permission to edit comments as well as the delete permission.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Chris Smith-Hill that does not sound like an ideal scenario at all. It would almost be worth removing those repeat-offenders' abilities to edit comments, so that they aren't messing with that data in post. I know I would be concerned if my QA were editing comments after the fact to hide that they didn't test something in the proper amount of time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found this thread because today, I see a comment that I definitely deleted showing up in the history and was wondering if this was toggle-able, since they never used to do this (and should not. a comment is deleted for a reason). So that's fun.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'd argue that it is essential to keep it in the history - this is an issue tracker, you want to know what people have done with it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.