BI Publisher – SQL to Return Knowledge Articles from Engagement Cloud

SELECT 
t.DOCUMENT_ID,
d.XML
FROM 
CSO_CONTENT_TEXT t INNER JOIN CSO_CONTENT_DATA d ON (t.RECORD_ID = d.RECORD_ID)
WHERE t.PUBLISHED = 'Y' AND t.LATEST_VERSION = 'Y' AND d.XML LIKE :faq

Leave a Reply

Your email address will not be published. Required fields are marked *