nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Dave Mathijs

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>,...)

All comments

Dave Mathijs

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management