Finding Keywords in Portal HTML Content

A CJ version of this query can be easily imported from a Suitcase: 4e5a7b48-104c-481d-8857-b5ce1148e9e0:rwf-test

Edit the LIKE filter to change what keyword you're searching for.

SELECT ptl__JID_.[name] AS [Portal Name]
    ,ptl__JID_.[key] AS [Portal Key]
    ,pv.[name] AS [View Name]
    ,pp.[name] AS [Part Name]
    ,ptl__JID_.[folder1] AS [Portal Folder]
    ,ptl__JID_.[active] AS [Portal Active Status]
FROM [portal] ptl__JID_
INNER JOIN [portal.view] pv
    ON pv.[portal] = ptl__JID_.[id]
INNER JOIN [portal.part] pp
    ON pp.[view] = pv.[id]
WHERE (
        /* Portal Part Filter */
        cast(pp.[html] AS NVARCHAR(max)) LIKE '%race%'
        )