Liferay Support does not recommend or endorse specific third-party products over others. Liferay is not responsible for any instructions herein or referenced regarding these products. Any implementation of these principles is the responsibility of the subscriber.
Issue
This article documents a method to create a possible query to do the following:
- determine how many pages are in a particular site; or
- determining which pages have global content
Environment
- Liferay Portal 6.2
- Liferay DXP
Resolution
- Refer to the database's
Layouttable to see which pages are on the portal. - To determine which pages are using global content, you can check your
Group_table to determine thegroupIdof your global site. - Next, search the
Portletpreferencestable to see which portlets are referencing thatgroupId. This indicates that a global content is being displayed. - Last, search for that
portletIdin theLayouttable to find which pages are using those portlets.
Note: Liferay Support does not endorse one database over another. You should always consult your database vendor's documentation.