JQL - search for parents issues with component that does not equal child issue component

Question

for example:

I have the following issue sin Jira:

* Epic ABC-123 with component filed value: 'Core' * Story QWE-456 with component field value: 'Product'
* Story ASD-789 with component field value: 'Core'

I want to do an advanced search to find all stories that does not have the same component as the epics they are attached to. (in the example above - the result will be

* Story QWE-456 with component field value: 'Product'

Muhammad Ramzan_Atlassian Certified Master_ · Answer

By using  JQL Search Extensions for Jira & reports   you can achieve your target search

you can use following query.

issue in allIssuesInEpic("component!=core")

Above query will get all issues part of epics where component is not core.

As you know the component name of Epic so you can mention that component where you don't want the child issues to be fetched.

So it will get all child issues where parent component does not exist in child issues.

epic TPL-21 with all child issues

Issues where component in child issues is not equal to component in parent. Since we know the component name in epic =core we simply negate it and it fetched all child issues where component is different than parent.

adi.geva · Answer

thank you for your answer.

i am looking for a bit of different thing:

(yourcomponent) is not a fixed value, and Epic is not the only parent i am looking at.

meaning, i want to see all child issues that their component value does not equal the parent component value.

Mohamed Benziane · Answer

Hello @adi.geva

Welcome to the community.

You can try this :

"Epic Link" = "ABC-123" and component not in (yourcomponent)

If you need something more dynamic you need an addon like scriptunner, you can take a look at the documentation here