Find out which macros are used within a space

Patrick Schneider

Hi,

I'm trying to find the Macro Usage for a specific Space. Sadly the macroName: * cql doesn't work. Is there another way to list used macros?

 

Best

Patrick

Patrick Schneider

For the interested with Database or XML Access:

- get SpaceID

select spaceid from spaces where spacekey = 'SPACENAME';

- get Content with Maco Usage

COPY(
SELECT bc.body,c.spaceid,bc.contentid,c.contentid,c.content_status,c.title
    FROM bodycontent bc
INNER JOIN content c ON c.contentid = bc.contentid
    WHERE c.spaceid = '123123213' and bc.body ~ '<ac:structured-macro ac:name')
to '/tmp/export.txt';

 - Grep the Export

grep -Po "ac:structured-macro ac:name=\K[^ ]+" export.txt | sort | uniq

 

Alternative to Database is the entities.xml in the Export.