Support Ticket Mass Close

[cloudrck]

I have about 2K worth of spam tickets I need to close. I remember seeing a mysql query to close all open tickets. Can't seem to find it, does anyone know if off hand?

[Michael]

Not sure I just open a few and close them. You can use the plugin P.V made in the marketplace to do this with the tick boxes. Which is easier but when you update Blesta the function need to be re-added.

[Ken]

This will mark all tickets in all departments closed.

UPDATE `support_tickets` SET `status` = 'closed'

Are you wanting to close them in a single department only? If so then you'll need to find the department ID in the 'support_departments' table and use the following. Where the number 1 is you'll need to change it to the department ID of choice:

UPDATE `support_tickets` SET `status` = 'closed' WHERE `department_id` = '1'

[Ken]

Also I've not utilized this yet but perhaps this might be useful?

 

http://www.blesta.com/forums/index.php?/topic/2001-support-manager-tickets-delete-merge-spam-multiple-tickets/

 

 

EDIT:  Ahh it looks like you already have.

Edited March 10, 2014 by Ken

[cloudrck]

 

This will mark all tickets in all departments closed.

UPDATE `support_tickets` SET `status` = 'closed'

Are you wanting to close them in a single department only? If so then you'll need to find the department ID in the 'support_departments' table and use the following. Where the number 1 is you'll need to change it to the department ID of choice:

UPDATE `support_tickets` SET `status` = 'closed' WHERE `department_id` = '1'

 

That's it, thanks. I was too lazy to go through the database and figure this out myself.

Also I've not utilized this yet but perhaps this might be useful?

 

http://www.blesta.com/forums/index.php?/topic/2001-support-manager-tickets-delete-merge-spam-multiple-tickets/

 

 

EDIT:  Ahh it looks like you already have.

Yes, but I didn't want to go through 10 pages and delete tickets