auto assign issues in round robin fashion

[wish_wish]

hi, i wonder if anyone know if there's a way for new issues to be auto assigned to developers in a round robin fashion.
or if there's a plug in for it.
thank you in advance.
ay

[efestione]

I am interested in the same feature.
Is this possible with Mantis?

Thank you

[atrol]

This is not possible out of the box.
You can auto assign by category.

You have to write a plugin or change the source code if you want round robin assignment.

[efestione]

Ok thank you

[kedorom]

Hi, this is possible. You should create a trigger in the database:

Example:
You have a support group with the users:
user_id User Name
1 Michael
2 Roger
3 Tatiana

This trigger will auto-assing a issue to the first user (1 - Michael), the next issue to the second user (2 - Roger), the next issue to the another user (3 - Tatiana), the next issue to the first user again (1 - Michael), etc.

CREATE DEFINER=`erodrigue`@`%` TRIGGER `mantis`.`mantis_bug_table_AFTER_INSERT` AFTER INSERT ON `mantis_bug_table` FOR EACH ROW
BEGIN
UPDATE mantis_category_table
SET user_id=(SELECT CASE (SELECT handler_id
FROM mantis_bug_table
WHERE mantis_bug_table.handler_id<>0
ORDER BY id DESC
LIMIT 1
)
WHEN 1 /*user id 1*/THEN 2 /*user id2*/
WHEN 2 /* user id 2*/ THEN 3 /*user id3*/
ELSE 1 /*user id 1*/
END);
END

You should be replace the user_id code in the trigger.

[pparihar]

Hello kedorom,

i am new on mantisbt and i have a project where i have to implement round robin auto ticket assign please help .