SQL Report: Portal Page Types Follow
Goal
I want to be able to run a report that will tell me which pages in a portal are structures (vs freeform or layout or URL). Ideally, I'd like to see URL or maybe page name; need to be able to identify the page
Query
Run the following query on the Production_Portal_PortalFx database. Naming conventions may vary from portal to portal.
SELECT PageID AS PageURL, DisplayText AS PageName, IsPublic, PageType, TemplateID, Tags, CreatedDate, PageTemplateID
FROM PWPages
ORDER BY PageType
To export the results to Excel, copy the query results. If the column headers do not copy over, follow the instructions on this article.
What do the PageType numbers mean?
PageType = 1 and TemplateID ends in Blank for Freeform (displayed as Passageways.IslandPageTemplates.Blank on query results)
PageType = 1 and TemplateID doesn't end in Blank for Layout
PageType =3 is a URL page
PageType = 4 for Structure pages
Comments
0 comments
Please sign in to leave a comment.