Skip to content
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 *