Exclude a page by label in an include content by label macro

If I have a bunch of pages about say fruit. They all have a label of 'fruit' and then a second label of the type of fruit it's about. Example 'apple' or 'orange' or 'strawberry'.

If I then used the Include content by label macro to include all pages with a label of 'fruit' but I wanted to exclude any apple pages how would I do that?

In the "Include content by label macro" labels form I have tried......

fruit,-apple or fruit -apple

+fruit,-apple or +fruit -apple

and have tired all of those with the operator of 'or' or 'and' and can't get it to work. What am I missing?

2 answers

The filtering by labels in content reports uses the inclusive OR.  This means that if your filter says Label A, Label B then Confluence will return all pages with "Label A OR Label B OR Both":


(An exclusive OR, which Confluence does NOT use, would return pages with "Label A OR Label B but NOT pages with Both").

To perform an AND - i.e. to return only pages with "Label A AND Label B" - you need to add a new filter line:


That will return those pages that have both "Label A AND Label B", in other words it won't return pages unless they have both of those labels.


In your specific case, you need "fruit AND NOT apple", so on the 1st line have "fruit" and on the 2nd line have "-apple".  This will give you "fruit AND NOT apple".


That makes great sense but I don't have an option to add a second label field filter. 



Suggest an answer

Log in or Sign up to answer
Community showcase
Published Dec 18, 2018 in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

458 views 3 18
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you