Customer external e-mail changed to internal note

Moderator: crythias

Locked
Chakr
Znuny newbie
Posts: 22
Joined: 04 Mar 2014, 17:27
Znuny Version: OTRS4

Customer external e-mail changed to internal note

Post by Chakr »

Hi everybody,

We want to change an e-mail sent by an Agent in reply to a ticket from customer external email to an internal note so that the customer cannot see it from the customer portal.

Or remove from the ticket, we tried the split function but the e-mail stays on the ticket and a new ticket is created.

How can we hide it from the customer portal?

Thanks a lot for your answers,
Chakr
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Customer external e-mail changed to internal note

Post by crythias »

it would take a database manipulation.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Chakr
Znuny newbie
Posts: 22
Joined: 04 Mar 2014, 17:27
Znuny Version: OTRS4

Re: Customer external e-mail changed to internal note

Post by Chakr »

Thx for your reply.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Customer external e-mail changed to internal note

Post by crythias »

The following is not recommended to do. BACKUP your database. Document your changes. UPDATING OTRS directly is frowned upon, can lead to data issues, etc. That said, this change is reasonably safe, except the History will believe it was different from what the article says.

Specifically, you can find the articleID in the URL
OTRS SQL Box
select at.name, a.article_type_id, a.a_from, a.a_to, a.a_subject from article a left join article_type at on a.article_type_id = at.id where a.id=[articleid]

select * from article_type

database:

If you have phpmyadmin, you could probably directly change this entry.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
skullz
Znuny superhero
Posts: 658
Joined: 24 Feb 2012, 03:58
Znuny Version: LTS and Features
Real Name: Mo Azfar
Location: Kuala Lumpur, MY
Contact:

Re: Customer external e-mail changed to internal note

Post by skullz »

Chakr wrote:Hi everybody,

We want to change an e-mail sent by an Agent in reply to a ticket from customer external email to an internal note so that the customer cannot see it from the customer portal.

Or remove from the ticket, we tried the split function but the e-mail stays on the ticket and a new ticket is created.

How can we hide it from the customer portal?

Thanks a lot for your answers,
Chakr
try to use email-internal instead of email external when reply..
My Github
OTRS CE/LTS Discord Channel
Cant Update Package Anymore ? Check This

Professional OTRS, Znuny & OTOBO services: efflux.de/en
Free and premium add-ons: English
Locked