Due Date - From Parent Ticket to Child Ticket

Question

Looking for a way to get items to flow from a Parent Ticket to a Child Ticket - specifically the Due Date field. We have a Parent ticket for new hires/changes/terminates, that when submitted, creates 3 child tickets, which are farmed out to different members in the IT team. The Due Date is not coming through for some reason, and is vital to the ticket.

Thanks.

FYI - I do not know SQL at all - so be gentle....lol.

Answer

So we have set up a rule that will copy data from the parent to the child, I have updated it so that it also includes the Due Date field as requested. So you may want to remove the custom fields

Select Statement

SELECT
HD_TICKET.ID,
HD_TICKET.CUSTOM_FIELD_VALUE0,
HD_TICKET.CUSTOM_FIELD_VALUE5,
HD_TICKET.DUE_DATE,
HD_TICKET.PARENT_ID,
PARENT_TICKET.ID AS P_ID,
PARENT_TICKET.DUE_DATE AS P_DUE_DATE,
PARENT_TICKET.CUSTOM_FIELD_VALUE0 AS P_CUSTOM_FIELD_VALUE0,
PARENT_TICKET.CUSTOM_FIELD_VALUE5 AS P_CUSTOM_FIELD_VALUE5,
PARENT_TICKET.IS_PARENT

FROM
HD_TICKET
LEFT JOIN HD_TICKET PARENT_TICKET ON HD_TICKET.PARENT_ID = PARENT_TICKET.ID

WHERE
HD_TICKET.PARENT_ID != "" AND HD_TICKET.HD_QUEUE_ID = 1 AND PARENT_TICKET.CUSTOM_FIELD_VALUE0 = 'High'

Update

UPDATE
HD_TICKET
LEFT JOIN HD_TICKET PARENT_TICKET ON HD_TICKET.PARENT_ID = PARENT_TICKET.ID
SET
HD_TICKET.CUSTOM_FIELD_VALUE0 = PARENT_TICKET.CUSTOM_FIELD_VALUE0,
HD_TICKET.DUE_DATE = PARENT_TICKET.DUE_DATE,
HD_TICKET.CUSTOM_FIELD_VALUE5 = PARENT_TICKET.CUSTOM_FIELD_VALUE5

WHERE
HD_TICKET.ID in (<TICKET_IDS>)