KACE Product Support Question
In KACE, is there a field that identifies a Process, similar to the Queue ID field (HD_TICKET.HD_QUEUE_ID )?
08/24/2016 770 views
I would like to write a ticket rule that changes the value of a custom field, based on which process the ticket belongs to. This is necessary because whenever a regular ticket is converted into a process ticket, fields in the original/parent ticket are not changed to the defaults defined in the process.
Answer Chosen by the Author
Please log in to answer
This will return the ticket IDs for tickets that:
Are in a process
Are a parent (or more technically don't have a parent)
Have a custom field 22 (CUSTOM_FIELD_VALUE21 in the table) value equal to N/A
SELECT HD_TICKET.ID FROM HD_TICKET
JOIN HD_SERVICE_TICKET on HD_SERVICE_TICKET.ID = HD_TICKET.SERVICE_TICKET_ID
JOIN HD_SERVICE on HD_SERVICE.ID = HD_SERVICE_TICKET.HD_SERVICE_ID
WHERE HD_TICKET.SERVICE_TICKET_ID != 0
and HD_TICKET.PARENT_ID = 0
and HD_TICKET.CUSTOM_FIELD_VALUE21 = 'N/A'
Answered 08/26/2016 by: chucksteel