How can I only display tickets that have exactly one specific value?

[Frederic Winters]

Hello everyone, we use the Components field. How can I only display tickets that have exactly one specific value? With components = XY, all tickets are displayed, but they can also have other components. I have to exclude this. Can anyone help me here?

[Dave Mathijs · Accepted solution]

Hi @Frederic Winters 

The only way is to explicitly exclude all other components, so I hope you don't have too many:

project = <projectname> AND component = <A> AND component not in (<B>,<C>,...)

[Frederic Winters]

I was afraid of that. Many thanks

[Dave Mathijs]

If it answered your question, thanks to click the green 'Accept answer' button.

[Hannes Obweger - JXL for Jira]

Hi @Frederic Winters,

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 based on regular expressions. 

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

(I'm using ^Component name$ here to indicate that the field should contain exactly the one component, and no others.)

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