Labellist macro on more than on space

Question

Hey there,

we have build a great wiki consisting of 10 spaces now.

To keep track of all the attached labels in those spaces, it would be nice to have an option to have an overview on all pages.

So far i tried to achieve this with the labels list macro, but this is just limited to one space if iam not mistaken. If i use the macro for each space, they all still show up separated and that is not what we are aiming for.

So the ultimate question: is there a possibility to create a list of labels from several spaces?

Thanks in advance!

Stephan Haas · Answer

Hey @Nicolai Sibler !

Thank you for pointing out this possibility. We'll look into it and this might be a workaround for this issue.

Much appreciated and with kind regards,

Stephan

Nicolai Sibler · Answer

Hi Stephan,

as a workaround, here's a SQL that returns all the labels of the instance and their count per space.

You could export the results to excel and attach the doc to a page if you want to view it in Confluence.

select s.spaceid,
s.spacename,
s.spacekey,
cl.labelid,
l.name,
count

from CONFLUENCE.CONTENT t

join confluence.spaces s
on t.spaceid = s.spaceid
and s.spacetype = 'global'

join confluence.content_label cl
on t.contentid = cl.contentid

join confluence.label l
on cl.labelid = l.labelid
and l.namespace = 'global'

where t.prevver is null 
and t.contenttype='PAGE' 
and t.content_status = 'current'

group by s.spaceid,
s.spacename,
s.spacekey,
cl.labelid,
l.name

order by s.spacename

Hope that helps!

Kind regards,

Nicolai

Stephan Haas · Answer

Good morning and hello to a new week again!

Assigning the 'Label List' macro to several spaces at once is not possible correct?