You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to remove img tag in BI Publisher Bursting Email Body ?

edited Dec 12, 2024 9:32PM in BI Publisher Learning Center

We are trying to retrieve the message content uploaded on the Help Desk Service Request

The following code has been used to remove html tag which were being triggered:

SELECT DISTINCT
'1' AS KEY
,ssr.TITLE
,hp.PARTY_NAME
,TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(UTL_I18N.UNESCAPE_REFERENCE(DBMS_LOB.SUBSTR(lam.MESSAGE_CONTENT, 1500, 1)),'<[^>]>',' '),'&[^;];',' '),''',''''), CHR(10), ' '), CHR(13), ' ')) message_content
,ssr.LAST_UPDATE_DATE
,hp.email_address

FROM
SVC_SERVICE_REQUESTS ssr
,HZ_PARTIES hp
,LatestAssigneeMessage lam
,SVC_CHANNEL_VIA svc

Note: Message content was retrieved from table SVC_SR_MESSAGES

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!