KACE Product Support Question
The update below sets a ticket owner ok, now I need to add also Ticket CC_List person to it and I don't seem have success.
I would appreciate your help.
update HD_TICKET, USER as T5
set HD_TICKET.OWNER_ID = T5.ID and
where T5.FULL_NAME = 'xxxxxxx' and
(HD_TICKET.ID in (<TICKET_IDS>))
Community Chosen Answer
update HD_TICKET, USER as OWNER
set HD_TICKET.OWNER_ID = OWNER.ID, HD_TICKET.CC_LIST = "firstname.lastname@example.org"
WHERE OWNER.FULL_NAME = 'xxxxx'
and HD_TICKET.ID in (<TICKET_IDS>)