Preskoči in pojdi v glavno vsebino

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

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

Seznam avtorjev

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.

Uporabno Neuporabno

36 od skupaj 90 oseb je ocenilo to stran kot uporabno.

Dodaj komentar

Pred objavo komentarja se moraš prijaviti.

Potrebuješ namig za geslo?