K1000 rule:Open a ticket automatically
I dont know if it is able but what i want is an automatically ticket from monday to friday at 15:30 in one of my queues.
I know that i have to select the email address of my servicedesk and send there the notification, in this way it will open a ticket, but what i dont figure out is the rest of the field and tables that i have to select, if i have to select any.
my code doest give me errors, but it doesnt send any email at all.
->Select SQL
select 1, 'servicedesk@mycompany.br' as email_servicedesk
from HD_TICKET
where curtime() = '15:30:00'
and DAYNAME(NOW()) NOT IN ('Saturday','Sunday') /* not the weekend */
->checkbox sending email
Assunto:
Coluna contendo endereços de e-mail: email_servicedesk
Mensagem:
3 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
select 1, 'servicedesk@mycompany.br' as email_servicedesk
from HD_QUEUE
where DATE(NOW())= '2014-12-17'
AND HD_QUEUE.ID = 7
and DAYNAME(NOW()) NOT IN ('Saturday','Sunday') /* not the weekend */
any ideas????
Thank you!! - Paloma 10 years ago
You can use the INSERT INTO command. Be careful though since doing this wrong can damage your database. - h2opolo25 10 years ago
for example:
insert into HD_TICKET (TITLE, HD_QUEUE_ID)
values('New Ticket', 1)
would make a ticket in queue 1 with just a title of New Ticket. It would not have a create date or anything. You can add that in to your insert statement and create a ticket this way. - h2opolo25 10 years ago