We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Question

Mechanism to identify and count pages produced from a specific Master Page

Is there a method to

(1) identify which pages were produced from which Master Page? I know how to see which Master Page produced any specific page, what I would like is a listing function for each Master Page without the need for building the list manually.

(2) produce a count for each Master Page

We have around 4000 pages produced from around 25 Master Pages and we want to see if we can improve our overall site management by consolidating onto fewer Master Pages. I’m aware of the need for care in terms of preserving the integrity of Regions in such a process.

Thanks

Stefan Youngs

Stefan Youngs 0 points

  • 7 months ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Is there a method to identify which pages were produced from which Master Page?

There's not an interface to do that, but it's simple to do. Look at the pageTemplate column in the perch3_pages database table.

Is there a method to produce a count for each Master Page

SELECT IF(LENGTH(pageTemplate)>0, pageTemplate, 'none') AS masterPage, COUNT(*) AS numberOfUses
FROM perch3_pages
GROUP BY pageTemplate
ORDER BY numberOfUses DESC