/build/static/layout/Breadcrumb_cap_w.png

"Undelete" Ticket Work Entries

This custom OTS (On Ticket Save) ticket rule will make it impossible for anyone in the KBOX console to delete ticket work entries.

Select Query:

SELECT HD_TICKET.ID AS ID FROM HD_TICKET JOIN HD_WORK ON (HD_TICKET.ID = HD_WORK.HD_TICKET_ID) WHERE HD_WORK.VOIDED_BY IS NOT NULL

Update Query:

UPDATE HD_WORK JOIN HD_TICKET ON (HD_TICKET.ID = HD_WORK.HD_TICKET_ID) SET VOIDED_BY = NULL WHERE VOIDED_BY IS NOT NULL AND (HD_TICKET.ID in (<TICKET_IDS>))


Comments

This post is locked
 
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