KACE Product Support

Hi all

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 Query:
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 Query:
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.

Thank you...