->Select SQL
select HD_TICKET.ID AS ID, HD_TICKET.TITLE AS TITULO,
HD_TICKET.CUSTOM_FIELD_VALUE1 AS DataDePendencia,
A.FULL_NAME AS ATENDENTE,
A.EMAIL AS EMAIL_ATENDENTE
from HD_TICKET
INNER JOIN USER A ON (A.ID = HD_TICKET.OWNER_ID)
WHERE HD_TICKET.CUSTOM_FIELD_VALUE1 = CURDATE()
GROUP BY HD_TICKET.TITLE
->Active the email checkbox and write the notification
Assunto: Data de Pendencia TICKET:[$id] $titulo
Coluna contendo endereços de e-mail: EMAIL_ATENDENTE
Mensagem: XXXXXXX
->Actualized SQL
update HD_TICKET
set HD_TICKET.CUSTOM_FIELD_VALUE1 = '0000-00-00'
where HD_TICKET.ID in (<TICKET_IDS>)
i tried to put it also with time, but i dont know why the time becames to 0 when you save the ticket, so it wasnt working at all. - Paloma 10 years ago