Search for pages without label

Fabian_Holz

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

Diego_88dj6o

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:

• [Confluence Cloud Developer] Advanced searching using CQL
• [Confluence Cloud Developer] CQL Fields
• [Confluence Cloud Developer] REST API

 

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:

 

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