Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How can I mass delete comments by date?

Alexander Dowga
Alexander Dowgailenko September 18, 2013

I enabled Jira's anonymous bug reporting/commenting feature but without any anti-spam protection. Now I have thousands of spam. I think I can safely do something akin to deleting all comments everywhere between two dates and get rid of 99.9% of spam. How can I do this?

Answer
Watch
Like Be the first to like this
348 views

1 answer

1 accepted

1 vote
Answer accepted
Jobin Kuruvilla [Adaptavist]
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 18, 2013

No way to do this from user interface. You might want to do this at database, Search for comments from jiraaction table between those dates and then remove them!

Do this only while JIRA is offline and reindex after it is back up.

View More Comments
Alexander Dowga
Alexander Dowgailenko September 22, 2013

this was the solution I needed. Quick, easy, painless. Thank you.

The query was DELETE FROM jiraaction WHERE actiontype="comment" AND id > [first id of spam]; worked great

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events