/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Helping in automatically populates title field with category and location

06/28/2014 1563 views

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


Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ