/build/static/layout/Breadcrumb_cap_w.png

Trying to use custom fields with-in ticket rules to auto send confirmation email.

I would like to be able to have a email sent to the user after they submit a ticket that has all the ticket details with-in the email. I used this the following link as my template from KACE support:


https://support.software.dell.com/kb/111222


For the most part it worked great. I use the HD_TICKET.CUSTOM_FIELD_VALUE1, which is the CUSTOM_2 field with-in Queue Customization page, but then when submit a test ticket with a test user, the email comes through, but it doesn't send the value that I selected. Would someone be willing to look at part my SQL Select?

SELECT

 -- ticket fields 

    HD_TICKET.ID, -- $id 

    HD_TICKET.ID AS TICKNUM, -- $ticknum 

    HD_TICKET.TITLE, -- $title 

    DATE_FORMAT(HD_TICKET.CREATED,'%b %d %Y %I:%i:%s %p') AS CREATED, -- $created 

    DATE_FORMAT(HD_TICKET.MODIFIED,'%b %d %Y %I:%i:%s %p') AS MODIFIED, -- $modified 

    HD_TICKET.CUSTOM_FIELD_VALUE1 AS VEHICLE, -- $Vehicle_Requesting

 -- change fields


Then in my "Message Body" I call $VEHICLE


Dear $submitter_fname, a ticket was created in response to your web submission. Your submission was: 

Department: $category 

Comment: $comment 

Vehicle: $VEHICLE


The "Department:" Value comes through (IE: Athletics, High School, etc.) in the e-mail, but the "Vehicle:" value is just "$Vehicle" for all tickets. Any suggestions?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: smillage85 8 years ago
White Belt
0
Sorry I figured out the answer, with-in the body of the message, I needed to use lowercase letters when I called "$vehicle"
 
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