/build/static/layout/Breadcrumb_cap_w.png

How do you force Parent to Child field updates in the Service Desk

I have a few fields that I am trying to pass from a parent ticket to a child ticket in the KACE Service Desk.  The fields that I need passed down are "Status", "Owner", and "Resolution". Can someone help me with the queries for this?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: svmay 7 years ago
Red Belt
1
Hello Bho1417,

to set the same owner from the parent ticket to the child ticket, I have the following customrule:
(The rule is in the parentticket queue)

sql-select:
SELECT HD_TICKET.ID, HD_STATUS.NAME, HD_STATUS.STATE, FILTER.CSTATE
FROM HD_TICKET
JOIN HD_STATUS on (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
JOIN
(SELECT HD_TICKET.ID, GROUP_CONCAT(CHILD.STATE) AS CSTATE
FROM HD_TICKET
JOIN HD_STATUS on (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
JOIN
(SELECT HD_TICKET.ID, HD_STATUS.STATE, HD_TICKET.PARENT_ID
FROM HD_TICKET
JOIN HD_STATUS on (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
WHERE HD_TICKET.PARENT_ID != 0)
CHILD ON (CHILD.PARENT_ID = HD_TICKET.ID)
WHERE HD_TICKET.IS_PARENT != 0
GROUP BY HD_TICKET.ID)
FILTER ON (FILTER.ID = HD_TICKET.ID)
WHERE HD_STATUS.STATE not rlike 'closed'

sql-select:
UPDATE HD_TICKET, HD_TICKET CHILD
SET
CHILD.OWNER_ID = HD_TICKET.OWNER_ID
WHERE
CHILD.PARENT_ID = (<TICKET_IDS>) AND
HD_TICKET.ID = (<TICKET_IDS>)

hope it helps!

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