/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


how can I default an Approver into the approver field base on certain criteria

08/19/2018 298 views

HI


I wanted to default the approver into the approver field based on certain criteria. But if I try and build a customer ticket rule the approver field is not one of the ones I can set.


Regards Tony

0 Comments   [ + ] Show comments

Comments


All Answers

0
You will have to manually edit the update portion of the rule to change the approver. It should look like this:
update HD_TICKET
    set HD_TICKET.APPROVER_ID = (select ID from USER where USER.USER_NAME = "theboss")
  where 
        (HD_TICKET.ID in (<TICKET_IDS>))
The theboss to the actual approver's username.


Answered 08/20/2018 by: chucksteel
Red Belt

  • while it finds the tickets it does not actually change the approver ID. I have hard coded it as well just to test.

    23/08/2018 10:00:08> Starting: 23/08/2018 10:00:08 23/08/2018 10:00:08> Executing Select Query... 23/08/2018 10:00:08> selected 4 rows 23/08/2018 10:00:08> Executing Update Query... 23/08/2018 10:00:08> updated 0 rows 23/08/2018 10:00:08> Ending: 23/08/2018 10:00:08
    • Please post your update statement.

Don't be a Stranger!

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

Sign up! or login

Share

 
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