Filtering Jira ticket to Exclude labels In Confluence

[jfuentes]

So currently the method suggested to filter labels is to use the "AND Labels=XYZ". But in reality this not help exclude labels only create a white list of Labels.  So what if the task have various labels and you only want to exclude one.  Are you saying I have to write a syntax for every label I want included?  That would be annoying if I have lets say 30 labels and only wanted to exclude 1 then I would have to write 29 AND Label syntax parameters. 

I would like to know how to exclude label not just include the ones I want

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @jfuentes ,

You may try the Table Filter and Charts for Confluence app. 

Wrap your Jira Issues macro in the Table Filter macro and set the required filter:

Here I use the Resolution field cause we don't use labels, but you may choose the Labels field or whatever field you need.

Then go to the Filtration tab and set the reversed filters to exclude items from your table:

Here is a screenshot for the page view mode:

It will be intuitive for your colleagues to choose what labels to exclude. 

The filter can also be saved for other users if required.

[Nic Brough -Adaptavist- · Accepted solution]

You could say "and labels != <unwanted label>"

[jfuentes]

AND labels != "discard"

[jfuentes]

It juts filters all but 2 which is odd because none of the one filter are the ones I wanted filtered