Hello!
I have some users who are bloating some confluence pages with macros which is causing slow performance.
Is there a for me to use the JavaScript API to count 1) The number of confluence macros currently used on the page 2) Get the names of these macros?
I looked at the AJS API and saw that there is a "AJS.params" object but couldn't find any macro info in there. Also examined the AJS.MacroBrowser API and couldn't find anything useful..
Any ideas?
If you have access to running a query against the database this will give you a list of your pages sorted by macro count per page.
select
C.CONTENTID,
S.SPACENAME,
C.TITLE,
(len(cast(B.BODY as nvarchar(max))) - len(replace(cast(B.BODY as nvarchar(max)), '<ac:structured-macro', ''))) / len('<ac:structured-macro') as MACROCOUNT
from CONTENT C
inner join BODYCONTENT B on C.CONTENTID = B.CONTENTID
inner join SPACES S on C.SPACEID = S.SPACEID
where C.PREVVER is null
and C.CONTENT_STATUS = 'current'
and C.CONTENTTYPE in ('PAGE', 'BLOGPOST')
order by MACROCOUNT desc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.