Moderator: crythias
This makes sense. They didn't create a ticket. This is just an add to an existing ticket.If I send an email to someone who hasn't a CustomerID and this person happen to reply to this email, it doesn't create that CustomerID.
I misunderstood this. So you're creating a new email ticket (not just an email) for someone who doesn't exist in your system and you want that user to be created as you create the the ticket?acterios wrote: ↑24 Apr 2019, 16:52 My OTRS setting PostMaster::NewTicket::AutoAssignCustomerIDForUnknownCustomers is currently set to enabled so everyone who sends an email to me gets a customerID if he doesn't already have one.
It happens that I need to send mail to people who haven't created a ticket yet, so I use Create New Email Ticket. The problem is, no CustomerID is auto assigned that way. Is there something I can do about it ?
Yes, I wasn't very clear about that but that's the point. Unfortunately, I don't have full access to my OTRS setup, I'll try to find another way to do this.I misunderstood this. So you're creating a new email ticket (not just an email) for someone who doesn't exist in your system and you want that user to be created as you create the the ticket?
Code: Select all
update ticket
inner join (
select id, (
select a_to
from article
inner join article_data_mime on article_data_mime.article_id = article.id
where article.ticket_id = ticket.id
order by article.id asc
limit 1
) as cid
from ticket
where (customer_id is null or customer_id = '') and
(customer_user_id is null or customer_user_id = '') and
(
select a_from like '%@DOMAIN>'
from article
inner join article_data_mime on article_data_mime.article_id = article.id
where article.ticket_id = ticket.id
order by article.id asc
limit 1
)
) x on ticket.id = x.id
set ticket.customer_id = x.cid,
ticket.customer_user_id = x.cid