Adding a description of the ticket in the email when the "Ticket Owner" changes
Hi,
Is it possible to add the "ticket description" in the email who's sent when a ticket is assigned to someone ? So the new owner can see directly in the email the description of the ticket.
Ex.:
-------------------------------------------------------------------
Ticket Updated.
----- Change by Superman at 01/17/2014 10:58:32 -----
Changed ticket Owner from "Unassigned" to "Batman".
"Ticket description HERE"
--------------------------------------------------------------------
Thanks in advance for your help,
7 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
I actually use a custom rule so that I can completely customise the email content, however I still only ever display the ticket title and a URL which links directly to the ticket.
Cheers. - twit 10 years ago
The purpose of adding the 'Ticket description" in the email that is sent when a technician gets a ticket assign to him, is to give a "first view" of the problem...
Thanks alot for your help ! - dtisoft 10 years ago
So, click 'Customize' next to custom ticket rules then 'Add ticket rule'. On the next few screens just click next, then done without entering anything until you get to the Ticket Rule Edit Detail screen. Here is my example:
Title: [Enter your title]
Order: 100
Notes: [Enter any notes]
Frequency: On ticket save
Enable: [Obviously tick this once your confident to have it running]
Select Query:
-------------------------------------------------------------------------------------------------------------------
select
HD_TICKET.ID as TICKNUM,
HD_TICKET.TITLE as TITLE,
OWNER.EMAIL as EMAILCOLUMN
from
HD_TICKET join HD_TICKET_CHANGE C on HD_TICKET.ID = C.HD_TICKET_ID
and C.ID = <CHANGE_ID>
join USER OWNER on HD_TICKET.OWNER_ID = OWNER.ID
where
C.DESCRIPTION like '%Changed ticket Owner from%'
-------------------------------------------------------------------------------------------------------------------
Only tick 'Send an email for each result row' then enter:
Subject: IT Request: $ticknum - Assigned to you
Email Column: EMAILCOLUMN
Email Body:
-------------------------------------------------------------------------------------------------------------------
Hello,
The above ticket has been assigned to you.
The ticket title is: [$title]
To access the ticket directly, click here: http://KBOXURL/adminui/ticket.php?ID=$ticknum
Thank you.
-------------------------------------------------------------------------------------------------------------------
Obviously (or maybe not obviously) what this does is, if it sees the words 'Changed ticket Owner from' when you click save, it generates this email to the new ticket owner.
I'm still not sure if this is giving you all the information you want though? I get the feeling you want the most recent comment or maybe even all comments in the email? Can you be a bit more specific with what you mean by 'Ticket Description'?
Or if this is all you wanted to accomplish, all good :) - twit 10 years ago
Thx, - dtisoft 10 years ago
In the SELECT query, under OWNER.EMAIL as EMAILCOLUMN, add this line:
C.COMMENT as COMM
Then, in the part where you type the contents of the email, add the line:
The most recent comment on this ticket was:
$comm
Let me know how it goes. - twit 10 years ago