Passer au contenu principal

How can I strip HTML from message content in my report? - Base de connaissances / Developer & Reporting / Creating Reports - Deskpro Support

How can I strip HTML from message content in my report?

Liste des auteurs

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.

Utile Peu Utile

35 personnes sur 88 ont trouvé cette page utile

Ajouter un commentaire

Veuillez vous connecter ou vous enregistrer pour soumettre un commentaire.

Mot de passe oublié ?