How do I create a filter for this? Parent / child

[Wendy Thorneloe]

Hi all

Can anyone help me with this?

I want to see all child issues from all the parents that have field PI set to PI 5

Show me all child issues (Story, Task) where parent (Feature) has  PI = PI 5.

How do I do this?

Thanks

Wendy

[Arka Ganguly]

You can use JIRA Query Language (JQL) to achieve this. Try the following query:

issueType in (Story, Task) AND "Parent Link" in (filter="Parent Issues with PI 5")

However, since JIRA does not allow direct querying of parent fields from child issues, you will first need to create a filter for the parent issues (Features) that have PI = PI 5.

Step 1: Create a filter for Parent Issues (Features)

Run this JQL and save it as a filter (e.g., Parent Issues with PI 5):

issueType = Feature AND PI = "PI 5"

Step 2: Query Child Issues

Now, use the saved filter in another JQL query to fetch child issues:

issueType in (Story, Task) AND "Parent Link" in (filter="Parent Issues with PI 5")

If you are using Advanced Roadmaps for Jira (formerly Portfolio for Jira), you can replace "Parent Link" with "Epic Link" if the parent-child relationship is through Epics:

issueType in (Story, Task) AND "Epic Link" in (filter="Parent Issues with PI 5")

Alternative (Using Scriptrunner)

If you have the ScriptRunner plugin, you can use this more direct JQL:

issueFunction in issuesInEpics("issueType = Feature AND PI = 'PI 5'")