How to Remove Edited Tag after Editing the Comment in JIRA
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
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.
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.
Solution
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 :
1update jiraaction set updated=(select created from jiraaction where id=10200) where id=10200;ℹ️ 10200 is the comment ID from the screenshot above.
Was this helpful?