Set ticket title from two custom field
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 :
set HD_TICKET.TITLE = HD_TICKET.CUSTOM_FIELD_VALUE0 HD_TICKET.CUSTOM_FIELD_VALUE1
(HD_TICKET.ID in (<TICKET_IDS>))