Helping in automatically populates title field with category and location
First of all I would like to thanks (John Verbosky) for his great articles and sharing us his knowledge.
Second I need some help to make some change in this rule code that I was taken from John's article.
This is the SQL code:
SELECT HD_TICKET.TITLE AS 'Title', HD_TICKET.CUSTOM_FIELD_VALUE2 AS 'Full Name', HD_TICKET.CUSTOM_FIELD_VALUE6 AS 'Date of Hire', HD_TICKET.ID AS 'ID' FROM HD_TICKET
WHERE (HD_TICKET.HD_QUEUE_ID = 2)
X Run an update query, using the results from the one above
UPDATE HD_TICKET T
SET T.TITLE = CONCAT(T.TITLE, ' - ', T.CUSTOM_FIELD_VALUE2, ' (', T.CUSTOM_FIELD_VALUE6, ')')
WHERE ((T.TITLE NOT RLIKE '^.+ [[.-.]].*') AND T.ID = <TICKET_IDS>)
The code in above compound two custom field
And my change is to compound category and one custom field
To get automatically populates title field with category and location (custom field 3 in UI, custom field 2 in SQL) after save.
Be the first to answer this question