/build/static/layout/Breadcrumb_cap_w.png

How do I delete or edit a comment left on our K1000 Service Desk?

Once a comment has been added to a ticket, can you remove just the comment? The ticket is still active, so it shouldn't be deleted. The comment has been taggeded for owners only, but it would be better to remove the comment.


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: chucksteel 10 years ago
Red Belt
1

The only way to do this would be to use a ticket rule. The safest way to do this would be to use a tool like MySQL Workbench to get the ID for the comment from HD_TICKET_CHANGE table and then use a ticket rule to run the following statement:

DELETE FROM HD_TICKET_CHANGE WHERE ID = <change id>

where <change id> is the ID for the comment to delete. You could also change the comment with a statement like this:

UPDATE HD_TICKET_CHANGE set COMMENT = "Inappropriate comment deleted" WHERE ID = <change id>

If you don't have access to MySQL Workbench you could also use a statement like this:

UPDATE HD_TICKET_CHANGE set COMMENT = "Inappropriate comment deleted" WHERE COMMENT = "Text of the offensive comment"

That should replace the comment that's offensive.

To run these statements use the rules wizard to create a blank rule (just accept the defaults) and then edit the rule to have one of the above statements in the select query. Then clear the other checkboxes for the rule and click Run Now.

 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ