I use a code very similar to this one linked, to send New Ticket emails to our IT department.

Is there a way to modify this line:

'helpdesk@mycompany.com' AS NEWTICKETEMAIL -- $newticketemail


So that i could include the emails in the CC field as well?

Answer Summary:
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


The CC field is stored in the CC_LIST column so if you can select it in the rule and use CC_LIST as the email column. If you want to email both helpdesk@mycompany.com and the addresses in the CC_LIST column then you would use the following:
concat_ws(',', 'helpdesk@mycompany.com', CC_LIST) AS NEWTICKETEMAIL

Answered 08/01/2014 by: chucksteel
Red Belt

  • Got the following error:
    mysql error: [1052: Column 'CC_LIST' in field list is ambiguous] in EXECUTE("SELECT -- ticket fields HD_TICKET.ID AS TICKNUM
    • Right. HD_CATEGORY also has a CC_LIST column and it's also included in the query. I should have specified HD_TICKET.CC_LIST.
      • Got it working now! Thanks very much for your help!
Please log in to comment