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

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

2 years ago

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