Custom Ticket Rule - Exclusion statement in the update query

For each site I have a rule which will automatically assign new  tickets to a specific owner.  There are some instances where the submitter and the queue owner are the same person and the ticket needs to go to the Help Desk. When manually assigning to Help Desk the rule automatically reverts back to queue owner.  How can I keep the rule from running if the submitter and user name are the same ? 

This is my current update query:

update HD_TICKET as T, USER as T5
    set T.OWNER_ID = T5.ID
    where T5.USER_NAME = 'Ted.Keller' and
        (T.ID in (<TICKET_IDS>))

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 years ago
Red Belt
Ok so I would suggest using a hidden switch field for when the initial rule runs, put simply configure a custom field, single select with 1 or 2, default value 1. Add to your rules to only run the rules when that field is 1 and set the value to 2 in the update rule.  This will then mean that the auto assign rules will not fire again. Once all the rules are working hide the custom field.

If you need any help with this feel free to get in touch

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ