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 Post navigation BI Publisher – SQL get user details BI Publisher – Get all resources from a The same Business Unit as a specific Resource User