Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,373
Community Members
 
Community Events
165
Community Groups

Search for pages without label

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

1 answer

1 accepted

1 vote
Answer accepted
Diego Atlassian Team 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!

Diego Atlassian Team Jun 29, 2020

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

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

360 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you