How to get the amount of pages with a certain label in Conflunce?

[Eduardo Llanos]

Is it possible without SQL?

I would like to use a plugin or existing Confluence functionality. 

[Jonathan Simonoff · Accepted solution]

I happen to have written a user macro to do this:

## Macro title: Count Labels
## Macro has a body: N
## Developed by: Jonathan Simonoff
## Date created: 8/12/13
## Installed by: Jonathan
## To count labels
## @param Label:title=Label|type=string|required=true|desc=The label to count
## @param Spaces:title=Spaces|type=string|required=false|desc=These are case-sensitive. Separate each item with a comma or single space. Example: SPACEKEY,@personal.  Blank means all spaces. 
#set($helper=$action.getHelper())
#set($pages=$helper.renderConfluenceMacro("{contentbylabel:labels=$paramLabel|showLabels=false|max=99999999|spaces=$!paramSpaces}"))
#set($pagelist=$pages.split("<li>"))
#set($count=-1)
#foreach($page in $pagelist)
 #set($count=$count+1)
#end
$count

[Marc Dvorschak]

Should this macro work with all Confluence versions? Because it doesn't seem to work with version 5.9.10. On our Confluence installation I get this error:

Error formatting macro: contentbylabel: com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql : null

Any ideas?

Regards, Marc

[Ashwin Somani]

Hi  Jonathan ,

Is this macro only work with label which are having single word like "testing", doesn't work with the label like "testing-ashwin" or "testing ashwin".

It is giving this error when i am trying this - 

[Vivek Lakshman]

Hi @Jonathan Simonoff ,

Could you please check the above query and let us know why are we getting that error?

[Ashwin Somani]

Hi @Jonathan Simonoff 

Could you check this or is this really not possible. Thanks!

[Lukas Knoch -Rumpelcoders-]

You could use Confluence search like this: 

labelText:chocolate

See also: https://confluence.atlassian.com/display/DOC/Confluence+Search+Syntax#ConfluenceSearchSyntax-Searchingforlabels

[Eduardo Llanos]

Thanks Lucas and Jonathan. The macro works like a charm