Need Help with JQL query to get children for multiple initiatives

Manisha Patel

 

Need Help with JQL query to get children for multiple initiatives.

. Children issue type can be Epic, task, subtask, story, user story.

Example - 

Need list for all issues under 4 initiatves.

project = EDA AND child of("EDA-1", "EDA-2","EDA-3","EDA-4")  

Here EDA-1,2,3,4 are initiatives and have childrens with different issue types.

Manoj Kumar Gangwar

Hi @Manisha Patel Welcome to the community! 

To get all child issues (Epics, Tasks, Subtasks, Stories, User Stories) for multiple initiatives in JIRA using JQL, you can use the issueFunction in hasLinks() function provided by the ScriptRunner plugin. However, if you don't have ScriptRunner, you'll need to use a different approach since JQL alone doesn't support querying multiple parent issues directly.

JQL-

project = EDA AND issueFunction in hasLinks("is child of", "EDA-1") OR issueFunction in hasLinks("is child of", "EDA-2") OR issueFunction in hasLinks("is child of", "EDA-3") OR issueFunction in hasLinks("is child of", "EDA-4")

 

If you don't have scriptRunner then use jql like-

project = EDA AND (parent = EDA-1 OR parent = EDA-2 OR parent = EDA-3 OR parent = EDA-4)