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

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share