How to find items having a specific set of labels and no other labels

[Henrik Carlsson]

Hi,

I'm looking for a way to find items having a specific label and excluding items that also have other labels. E.g. If I look for items having label "Alpha" I'd like to find  all items having *only* "Alpha" as label and NOT those where "Alpha" is one out of several labels.

In our instance we have several hundreds of labels so there is no chance of excluding "all others" by proving a list of those to exclude. 

[Hannes Obweger - JXL for Jira]

Hi @Henrik Carlsson,

if you are open to solutions from the Atlassian Marketplace, this would now be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

(I'm using components here but it would work exactly the same way with labels.)

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes