/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Help mail to cc_list k1000

11/19/2015 776 views
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

Be the first to answer this question

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