/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Email Variables not working for custom field

09/26/2014 2374 views
I have modified the "ticket modified" service desk email notification as seen below.  I cannot get the row "Ticket Detail: $ticket_CUSTOM_3" to display the data that is in that field.  Can someone please advise what I am doing wrong.  When the emails are sent, everything works, but that row just says ticket detail: $ticket_custom_3.

Ticket Updated.
Ticket Summary: $ticket_title
Ticket Status: $ticket_status
Ticket Detail: $ticket_CUSTOM_3

Last Update: $change_desc

Ticket History
----------------------------------------------------------------
$ticket_history
_____________________________________________
For complete details, see:
    $ticket_url

0 Comments   [ + ] Show comments

Comments


All Answers

0
You need to make sure it's the same name in the SQL Select query.

For example:

SELECT HD_TICKET.CUSTOM_FIELD_VALUE2 AS TICKET_CUSTOM_3

then you can use the TICKET_CUSTOM_3 variable in your email which will point to CUSTOM_FIELD_VALUE2 which is really CUSTOM_FIELD_3 in the GUI. Welcome to KACE konsistency!

In your case I don't think there's anything to edit SQL wise so you have to use the actual name which should be $CUSTOM_FIELD_VALUE2 or $CUSTOM_FIELD_3. I'm not where I can access my KBOX to test but something like that should work.
Answered 09/26/2014 by: h2opolo25
Red Belt

 
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