Rule to dispatch technician - auto assign owner
I have a help desk where calls that come in will either be solved on the phone or sent over to a separate technicans group. I created a checkbox that says "Dispatch technician?" that I'd like to have the help desk check off if they need to dispatch a technician. I created a ticket rule that identifies if the ticket does not have an owner and if the checkbox is checked that will assign to the technician dispatcher but it keeps reassigning the tickets to him no matter what (even if the checkbox is unchecked). I'm using the wizard and I have the following criteria:
Criteria:
Owner User Name is NULL
and Dispatch Technician? = 1
Change:
Owner User Name change value to 123456
The rule seems to work when I create it but then it just keeps assigning them to the dispatcher no matter what.
-
Perhaps try editing the SQL to add a check on the last modified date. Then edit your SQL code for your rule to only run if the ticket has been updated within the last 15 minutes. Set your rule to run every 15 minutes. Just a suggestion. - Jbr32 9 years ago
-
Can you post the SQL code for the select statement and the update statement? - chucksteel 9 years ago
-
I imagine you could add a second criteria such as " status = New " then change that to "status = Assigned" so it would not trigger later. - MacDude 9 years ago
Answers (2)
