Auto assign tickets, how it work ?

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
grégory
Posts: 2
Joined: Fri Dec 13, 2013 10:40 am

Auto assign tickets, how it work ?

Post by grégory »

Hesk version : 2.5.1

Hello everyone,

I would like to know how the tickets are scattered. Let me explain, I have two users who are self assignment ticket. The problem is that they are not scattered evenly. A user has received 19 tickets, the other was 47.

Is it a bug ? Is it configurable ? :?:

Thank you and have a nice day. :)
grégory
Posts: 2
Joined: Fri Dec 13, 2013 10:40 am

Re: Auto assign tickets, how it work ?

Post by grégory »

It's ok.

Whoever has the least ticket will receive a ticket.

I saw the request :

SELECT `t1`.`id`,`t1`.`user`,`t1`.`name`, `t1`.`email`, `t1`.`language`, `t1`.`isadmin`, `t1`.`categories`, `t1`.`notify_assigned`, `t1`.`heskprivileges`,
(SELECT COUNT(*) FROM `hesk_tickets` FORCE KEY (`statuses`) WHERE `owner`=`t1`.`id` AND `status` IN ('0','1','2','4','5') ) as `open_tickets`
FROM `hesk_users` AS `t1`
WHERE `t1`.`autoassign`='1' ORDER BY `open_tickets` ASC, RAND()


Bye
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: Auto assign tickets, how it work ?

Post by Klemen »

Correct, the person with least OPEN tickets will get autoassigned.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply