/build/static/layout/Breadcrumb_cap_w.png

Send emails to user named in a custom ticket field

I have created a "requestor" field in my service desk that links to the users table. This field is meant to function much like the fixed submitter field but in using it, I can restrict user access to submit tickets to particular queues while still allowing the technicians to place tickets on their behalf into those queues.

The field itself works fine but I need for the same emails that ordinarily are sent to submitters on ticket creation, closure, etc. to send instead to the user named in this requestor field. I am sure I need a custom rule to do this but I can't think of how to link it specifically to the email address connected to the user in the custom field.

0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: chucksteel 8 years ago
Red Belt
1

Top Answer

The custom field is most likely storing the user ID in the database so you can use that to link to the user table. If the custom field is field 1 then the column in the database will be CUSTOM_FIELD_VALUE0, custom field 2 is CUSTOM_FIELD_VALUE1, etc. 

The join to the user table would look like this:
JOIN USER REQUESTOR on REQUESTOR.ID = HD_TICKET.CUSTOM_FIELD_VALUE0

In the select portion of the query you can get the email address like this:
REQUESTOR.EMAIL as REQUESTOR_EMAIL

For the rule the column containing the email address then becomes REQUESTOR_EMAIL.

 
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