Setting a custom Due Date in Help Desk Ticket
My question is, Can I have the due date default to 7 days in the future from when the ticket is first open. Currently it is set to None. Would I need to edit a new help desk sql rule? If so what would the syntax be? Please help. I saw this in another post - just don't know if pasting it in the NewSQL rules would do anything:
update HD_TICKET as T
set T.DUE_DATE = DATE_ADD(T.CREATED, INTERVAL 14 DAY)
(T.ID in (<TICKET_IDS>))
I would like to have it at 7 days - so obviously would need to change the interval. Any help is appreciated, thanks.