Question:
I have a report that includes ticket messages, but tickets created from email contain a lot of HTML tags so the message is hard to read. Is there anything I can do?
Answer:
In your report, instead of ticket_messages.message, use:
LEFT(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(tickets_messages.message, '<div>', ''), '</div>', ''), '<p>', ''), '</p>', ''), '<br />', ''), 25) AS 'Preview'
This will strip out the most common tags inserted by email clients, and make the messages more readable.
Fügen Sie einen Kommentar hinzu
Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.