/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Ticket rule to add 15 minutes time to Work Adjustment. - SQL

07/31/2019 227 views

I'd like to create a ticket rule that if Custom_20 is not null that it adds 15 minutes to work adjustment.


Reason being, we've a daily ticket that we carry out and want to simplify adding work done to it.


Got his far:

update HD_TICKET

    set HD_TICKET.CUSTOM_FIELD_VALUE19 = '0'

  where 

        (HD_TICKET.ID in (<TICKET_IDS>))

update ORG1.HD_WORK

    set HD_WORK.MODIFIED='.25'

Any ideas anyone?


3 Comments   [ + ] Show comments

Comments

  • Firstly you need to make sure that you custom field contains a value, I'm not sure but from a few releases back setting a default value of '0' seemed to fail. We used this mechanism as a switch field regularly before KACE "Broke" it, so I would suggest a default value of 1 rather than 0. Also your update surely needs to be set as a sum so that it adds time to the work completed, or is it just a default value that you want to set to assume that there is work done?
  • yeah, a set sum if 15 ever time. that's .25 hours.
  • yeah, a set sum if 15 ever time. that's .25 hours.

Be the first to answer this question

 
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