Set ticket title from two custom field
Hello,
I'm testing a rule to update the ticket title with the value of two customs field.
It work's but only with one custom field.
How should I write my SQL request ?
See the sql update request that not work :
update HD_TICKET
set HD_TICKET.TITLE = HD_TICKET.CUSTOM_FIELD_VALUE0 HD_TICKET.CUSTOM_FIELD_VALUE1
where
(HD_TICKET.ID in (<TICKET_IDS>))
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
KevinG
3 years ago
You will want to look at the use of the "concat".
Returns the string that results from concatenating the arguments.
Comments:
-
I should use "concat" in the "select SQL" or in "update SQL" ? - service.informatique@faun.fr 3 years ago
Posted by:
service.informatique@faun.fr
3 years ago
Top Answer
I've do with that in the update SQL request :
update HD_TICKET
set HD_TICKET.TITLE = concat('Nouvel entrant : ',HD_TICKET.CUSTOM_FIELD_VALUE0,' ',HD_TICKET.CUSTOM_FIELD_VALUE1)
where
(HD_TICKET.ID in (<TICKET_IDS>))