/build/static/layout/Breadcrumb_cap_w.png

K1000 Service Desk Custom Ticket Rules

Ive setup the Service Desk with a Custom Ticket Field called "Hold Till" (set on CUSTOM_2)

I want to be able to have a Ticket Rule to check the "Hold Till" Field and if the date is "Today's Date" (every morning the schedule runs) to change the states from on Hold to Open.

Ive seen a few posts about this but i cant quite get my head around it on what i need to add or set, any help would be amazing. If ive missed out any information please let me know. i am on the latest version 6.4.120756

Thanks Again

Ash

1 Comment   [ + ] Show comment
  • So I've set a Ticket Rule using the wizard as the following:

    status = On Hold
    And
    Hold Till is not null

    then went in and changed the value to
    AND HD_TICKET.CUSTOM_FIELD_VALUE1 = CURDATE()

    Vales to change Ive just simply set
    Status Change Value to = new

    in the Update SQL i also added the line: HD_TICKET.CUSTOM_FIELD_VALUE1 = Null
    this then cleared down the value in the date field

    Ive tested this and this works like a charm. - ashbroom 8 years ago

Answers (1)

Answer Summary:
Posted by: ashbroom 8 years ago
White Belt
1

Top Answer

So I've set a Ticket Rule using the wizard as the following:

status = On Hold
And
Hold Till is not null

then went in and changed the value to
AND HD_TICKET.CUSTOM_FIELD_VALUE1 = CURDATE()

TL6CNk.png

in the Update

Status - Change Value to = new

in the Update SQL
added the line: HD_TICKET.CUSTOM_FIELD_VALUE1 = Null
This then cleared down the value in the Custom field

SHL1i4.png

Ive tested this and this works like a charm.
 
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