Submit Feedback
Legacy Knowledge Base
Published Jun. 30, 2025

How to Query for Javascript Alerts in Web Content Articles across multiple sites

Written By

Michael Tran

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

  • How do I search for Javascript Alerts that are located in Web Content Articles across different Liferay sites?

 

Environment

  • Liferay 7.4

 

Resolution

  • The overall approach towards querying the alerts is:
    1. Get a list of Web Content articles that have the "alert(" Javascript code in them.
    2. Get a list of Pages that are displaying these articles.
  • To get a list of Web Content (Also Known As Journal Articles) that include "alert("
    SELECT * FROM JournalArticle WHERE id_ IN (SELECT storageId FROM DDMFieldAttribute WHERE smallValue LIKE '%alert(%' OR largeValue like '%alert(%')
  • Get a list of Pages that are displaying these Web Content Articles. The following query takes advantage of the LayoutClassedModelUsage table: 
SELECT * FROM Layout WHERE plid IN (SELECT plid FROM LayoutClassedModelUsage WHERE classNameId IN (SELECT classNameId FROM ClassName_ WHERE value = 'com.liferay.journal.model.JournalArticle') AND classPK IN (SELECT resourcePrimKey FROM JournalArticle WHERE id_ IN (SELECT storageId FROM DDMFieldAttribute WHERE smallAttributeValue LIKE '%alert(%' OR largeAttributeValue like '%alert(%'))
  • If the desired web content is general content returned from external web sources outside of Liferay, one of the areas to check is in Fragments. Please refer to the sample query below if this is the case:
SELECT * FROM Layout WHERE plid IN (SELECT plid FROM FragmentEntryLink WHERE html LIKE '%alert(%' OR js LIKE '%alert(%' OR configuration LIKE '%alert(%' OR editableValues LIKE '%alert(%')

 

 

Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?