In Kace Service Desk, I am wanting to have data that is entered in to a single field (Username) to be added to a separate field (Title).
Ideally with out overwriting the (title) field but just adding to it
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
Hobbsy
4 years ago
You need to use a concatenate for the values, so you need an update statement something like this
UPDATE
HD_TICKET
SET HD_TICKET.TITLE = CONCAT((SELECT HD_TICKET.TITLE), " : Username : ", (SELECT USER.FULL_NAME FROM USER WHERE USER.ID = HD_TICKET.CUSTOM_FIELD_VALUE11))
WHERE HD_TICKET.HD_STATUS_ID = 123 AND HD_TICKET.TITLE NOT LIKE '% : Username : %'
