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