hi,
I need help about this topic: http://www.itninja.com/question/auto-populate-cc-list#answer-97699
This solution don't work anymore since 6.2 and i'm on 6.3. So is there a solution or another SQL request for put the mail adress in cc_list?
Ty !
3 Comments   [ + ] Show Comments

Comments

  • Can you post your current select and update queries?
  • Select:
    SELECT HD_TICKET.* FROM HD_TICKET
    WHERE HD_TICKET.HD_QUEUE_ID = 1

    Update:
    HD_TICKET as T
    SET T.CC_LIST = SELECT T.CUSTOM_2 FROM T
    WHERE T.CC_LIST=' AND T.ID in (<TICKET_IDS>)
  • I don't know for sure, but maybe the second line of the update query should be something like:
    SET T.CC_LIST = SELECT T.CUSTOM_FIELD_VALUE2 FROM T
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share