Deleting Groups which have tickets assigned to ...

lazouche · **Deleting Groups which have tickets assigned to ... -** 13-05-2008, 11:21 PM

Hello,

We had originally two groups in our kayako as it was for two different companies. Now we are merging everything into ONE.

In the tickets view, we see that many tickets are associated to the group we want to delete and only keep the other one. SO questions are:

1) How can we move ALL the tickets from a certain group to another group ??

2) If number 1 cannot be done, if we delete the group we want deleted, what will happen to all the tickets which are assigned to that group ??

Please help us in finding a solution to this

Thank You

craigbrass · 14-05-2008, 08:12 AM

Only way would be to go into the database using phpMyAdmin and run SQL queries on the database.

lazouche · 14-05-2008, 02:28 PM

Hello,

OK so what happens if we delete the group?? What happens to the tickets assigned to it??

Thank You

craigbrass · 14-05-2008, 02:46 PM

They just sit not assigned to anything so you can't view them via the staff interface. V4 will hopefully see the options to move into another group or delete them when deleting a group with any luck save these manual SQL queries having to be run.

lazouche · 14-05-2008, 03:00 PM

So that means, we cannot delete the group ?? Can you provide a complete solution to this problem including the SQL queries to run if that is the only solution ...

Thanks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The SLA system explained with example implementation	Matthew	SupportSuite, eSupport and LiveResponse	27	09-05-2008 05:52 PM
Using Template Groups - A Tutorial	Matthew	How do I?	5	07-05-2008 10:37 AM
InstaAlert - Only Notify of Tickets Assigned to Specfic User	adamrb	InstaAlert	10	09-04-2008 09:30 PM
Horrible SLA Problems	Emma	SupportSuite, eSupport and LiveResponse	26	26-10-2007 09:03 AM

craigbrass Offline Senior Member Posts: 4,955 Join Date: Jun 2005 Location: Cumbria, UK SupportSuite Owned License	14-05-2008, 08:12 AM Only way would be to go into the database using phpMyAdmin and run SQL queries on the database. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

lazouche Offline New Member Posts: 4 Join Date: Nov 2007 SupportSuite Owned License	14-05-2008, 02:28 PM Hello, OK so what happens if we delete the group?? What happens to the tickets assigned to it?? Thank You

craigbrass Offline Senior Member Posts: 4,955 Join Date: Jun 2005 Location: Cumbria, UK SupportSuite Owned License	14-05-2008, 02:46 PM They just sit not assigned to anything so you can't view them via the staff interface. V4 will hopefully see the options to move into another group or delete them when deleting a group with any luck save these manual SQL queries having to be run. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

lazouche Offline New Member Posts: 4 Join Date: Nov 2007 SupportSuite Owned License	14-05-2008, 03:00 PM So that means, we cannot delete the group ?? Can you provide a complete solution to this problem including the SQL queries to run if that is the only solution ... Thanks