How do I exclude extra components in the data return from a Jira query?

[Chris]

Running a query on an Epic based on Components. Problem is, each story/bug has multiple components attached. So my query is to get all that have ex. "02 Maintenance", but the return shows all those and also includes all the other components in those tickets. I want to be able to see all my issues with "02 Maintenance", but I don't want the return data to show the other components on those issues. Trying to get it whittled down to use for a dataplane report. 

I tried just using the basic, component not in (Ex1, Ex2), but that will exclude all the issues that have that, but also have my wanted component. 

I also tried something like (component = "02 Maintenance" and component not in "Ex1, Ex2)) but that will exclude some of the issues I want that have both the component I want and the Ex1. 

Any ideas? Or is it because the component field is multi, you can't exclude pieces from it?

[Ste Wright]

Hi @Chris 

It isn't possible to modify your results natively in this manner - the results will show all options selected in multi-select fields, not just one.

There is a workaround though...

• Create a custom field to either capture the component, or confirm it is set - eg.
  • Checkbox Field = Yes if component in use
  • Select List (single choice) Field = Set value if component in use
• Use Automation to populate this field
• Use this field in the search results instead

Ste

[Chris]

Just to note, the data we're trying to show is just to be used by business partners for tracking, not for reporting.