Write Ticket Values as a Comment
I have several ticket queues setup for different departments. I also have some rules that automatically move a ticket from one queue to the other based on certain conditions.
I'm looking for a method to write the value of a custom field as a comment. I was hoping by defining the custom field in the select statement I could then use that variable in the "Append comment to ticket" the same way I would when sending emails. However either I'm doing something wrong or that's not supported.
-- ticket fields
HD_TICKET.CUSTOM_FIELD_VALUE6 AS SETUP_NAME, -- $setup_name
HD_TICKET.CUSTOM_FIELD_VALUE3 AS NMLS_NAME, -- $nmls_name
HD_TICKET.CUSTOM_FIELD_VALUE0 as BRANCH_NAME, -- $branch_name
HD_TICKET.CUSTOM_FIELD_VALUE1 as JOB_TITLE, -- $job_title
If I try to use $setup_name in the "Append comment to ticket" it simply displays as "$setup_name" whereas if I use that in building an email it shows the field value.
Has anybody done this, I'm assuming I will need to do this as an update query. If anybody has an example on how to make this work that would be great.
There are no answers at this time