Page 1 of 1
ticket assignment
Posted: Mon Oct 17, 2011 9:10 pm
by webguy78
Title: HESK
Version: HESK 2.3
I have upgraded from HESK 2.2 to HESK 2.3 and now two of my users have been assigned the wrong tickets. Is there a way I can unassign all there tickets all at once?
Re: ticket assignment
Posted: Tue Oct 18, 2011 2:58 pm
by Klemen
There is no tool for bulk assign/unassign in HESK I'm afraid.
If you know how to use phpMyAdmin and SQL you could try editing the database:
Code: Select all
UPDATE `hesk_tickets` SET `owner`='0' WHERE `owner` IN (13, 15)
where "13" and "15" are ID number of the two staff members.
Re: ticket assignment
Posted: Tue Oct 18, 2011 3:04 pm
by webguy78
So if I remove the techs from 13 and 15 then the tickets will be unassigned again
Re: ticket assignment
Posted: Tue Oct 18, 2011 3:33 pm
by Klemen
If you are NOT familiar with phpMyAdmin and SQL then forget what I am writing and manually modify tickets from the HESK admin panel.
If you are familiar with the above, then:
Step #1:
in the database, find ID numbers of the two uses (in hesk_users)
Step #2:
use the code I provided to unassign all tickets from them, just replace "13" and "15" with the actual ID numbers of the two users that you got at step #1.
Re: ticket assignment
Posted: Wed Oct 19, 2011 2:59 pm
by webguy78
Ok, I'll try the database fix. I definitely want to nominate that you add a unassign all my tickets for the next update.