Search for pages without label

Fabian_Holz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 26, 2020

Hi,

I have a set of pages, labelled as "active" or "inactive". It's important to me, that all pages have one of those labels.

As it might be that I forget to label a new page, I need to find unlabelled pages in my space (without checking each page one by one).

Unfortunately I was not able to find a way to search for unlabelled pages. All the solutions I found are very old and it seems, that those functions are not included in Confluence anymore.

Any ideas?

Regards

Fabian

2 answers

1 accepted

6 votes
Answer accepted
Diego
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 27, 2020

Hello @Fabian_Holz !

As I understand, you need to search for all pages within a specific Confluence Space and those pages should not contain a specific list of labels.

 

There is a native way for us to get those results. It involves Confluence Query Language (CQL) and Representational State Transfer Application Programming Interface (REST API).

Here you can check our documentation:

 

Now, here is how we can get the desired content:

  1. Go to your Confluence site
  2. Go to your desired space
  3. Take note of the Space Key for that specific space
  4. Use the following query: https://yoursite.atlassian.net/wiki/rest/api/search?cql=label?NOT?IN("yourlabel","yourlabel2")?AND?type="page"?AND?space=YOURSPACEKEY
  5. The results should give you all the pages that do not contain the labels

A little explanation of the query above.

  1. The "https://yoursite.atlassian.net/wiki" is your Confluence Site URL. You must replace the "yoursite" part with your site name.
  2. The "/rest/api/search" part tells Confluence you are asking for a REST call for a search
  3. The "?cql=label?NOT?IN("yourlabel","yourlabel2")?AND?type="page"?AND?space=YOURSPACEKEY" part is the actual query. You must replace "yourlabel", "yourlabel2", and "YOURSPACEKEY" with your desired labels and space key.
  4. Each "?" character is used to symbolize where a white space would be placed
  5. The type=”page” is what assures that the results will contain only pages and no blog posts, for example.

 

You can get your Space Key under Space Settings:

Screen Shot 2020-05-27 at 12.26.23.png

 

Let me know if there is anything else I could assist you with!

Fabian_Holz
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 15, 2020

Thank you :)

Diego
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 29, 2020

Glad to know the query helped you! Let me know if there is anything else we could help you with.

Kevin Meehan April 12, 2022

Hi there,

Apologies for resurrecting an older post...

I can't seem to get this query to work as OP requested: to return all pages within a Space that don't have a label.

What does ("yourlabel", "yourlabel2") in the query signify?  The labels to be excluded from the result? 

So I would have to declare all labels in use within that query to effectively display the pages that don't have any?  Is that the gist of it?  And if I forgot a particular label, then those pages would also be included?

I am just looking for any solution that can provide this result, ideally a macro, but I will settle for a script or advanced query I can save and run periodically...

Thanks

Like Slava Gefen likes this
Jawann
Contributor
August 1, 2024

There is a request here to add a null value check to CQL: https://jira.atlassian.com/browse/CONFCLOUD-76379

Like # people like this
1 vote
Slava Gefen
Contributor
October 6, 2024

Sorry, but why was the answer accepted?

Do I really need to exclude all my 1000+ labels to find pages without labels?

And from the other hand: how to find pages containing any label?

With kind regards
Slava

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events