/build/static/layout/Breadcrumb_cap_w.png

K1000 Ticket Comments in ticket change notification

Hello,

I was wondering if there is a way to somehow add ticket comments to the ticket change notification.  An example of this is that if the user updates their ticket via email, I would like to see that comment in the change notification instead of having to go to the service desk to look at the ticket.  I have added "$ticket_history" to the ticket change notification email but that shows a lot of information and I would like to limit that to just the comments made in the ticket.

Thanks for your help.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: nimexx 10 years ago
Blue Belt
0

On ticket save, CHANGE_ID is populated for custom rules with whatever change was made.

You can display whatever comment was made in that specific change as well as the change description which would be for other fields that changed. 

A query something like this would do that:

SELECT HD_TICKET.ID AS ID,HD_TICKET.TITLE, SUBMITTER.FULL_NAME AS SUBMITTER_FNAME, C.COMMENT,C.DESCRIPTION from HD_TICKET
LEFT JOIN USER SUBMITTER ON SUBMITTER.ID = HD_TICKET.SUBMITTER_ID
JOIN HD_TICKET_CHANGE C ON C.HD_TICKET_ID = HD_TICKET.ID AND C.ID=<CHANGE_ID>

email body:

Title: $title
Ticket: $id
From: $submitter_fname
$description
$comment


This would not display all comments.  It might be possible to do a subquery and concatenate all comments though.  Ir may not display even that last comment unless that comment was made on that specific CHANGE_ID.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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