What should be the filter query for searching tickets having only a specific component?

[Sucharita Maity]

Example Case:

Search all tickets having component 'example'. Note: tickets that have other component(s) along with 'example' should not be included in the result.

What should be the JQL filter query for above case?

[Hannes Obweger - JXL for Jira]

Hi @Sucharita Maity

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would 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 long list of so-called smart columns that aren’t natively available, including the number of components.

With these, you can easily filter down to the issues with one particular component, like so:

This all just works - there's no scripting or automation whatsoever required. 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.

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Cristian0791]

Hi Sucharita,

You can try:

1. make a filter based on JQL: component = example

2.Export the report in XLS

3.Then you need to create a filter in Column: Component that will bring only one component (does not contain ","that is the separator)

4.Now you have all single values result and you can sort via: example

Hope this will help