How to Remove Edited Tag after Editing the Comment in JIRA

Still need help?

The Atlassian Community is here for you.

Ask the community

The information in this page relates to customisations in JIRA. Consequently, Atlassian Support cannot guarantee to provide any support for the steps described on this page as customisations are not covered under Atlassian Support Offerings. Please be aware that this material is provided for your information only and that you use it at your own risk. Please try the workaround/resolution on your staging/development/testing JIRA instance database before performing any changes on production JIRA instance database.

Summary

The purpose of this article is to show how to remove the "Edited" tag on a comment that has been edited in JIRA. For example, if you are updating comments to set the security level for comment visibility and don't want and the "Edited" tag is not relevant, you can perform the following to remove the tag. This can be done by updating updated field value to be the same as created field value in jiraaction table in JIRA database. 

Workaround

Ensure to backup your database before attempting any changes.

 

 

  • For this example above, the database is updated by looking at the comment itself, which is actionbody field in the database. In this case, the updated comment ID is 10200. Please refer to the screenshot above on how to obtain the comment ID, you will need to hover your mouse to Edit button and observe the URL below the page.

  • Log in to JIRA database.
  • Run the following SQL command to update updated field value in jiraaction table :

    update jiraaction set updated=(select created from jiraaction where id=10200) where id=10200;

    (info) 10200 is the comment ID from the screenshot above.

Last modified on Nov 2, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.