Hello, We have realized the following (possible) structure / hierachy in our JIRA: * Initiative --> Epic --> Task --> Sub-task * Initiative --> Task --> Sub-task Adaptavist ScriptRunner for JIRA is installed. Question: With which JQL query do we get all childs from an Initiative (INIT-1) up to all Sub-tasks?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Childs from Initiatives up to Sub-tasks

Per Wilhelm

Hello,

We have realized the following (possible) structure / hierachy in our JIRA:

Initiative --> Epic --> Task --> Sub-task
Initiative --> Task --> Sub-task

Adaptavist ScriptRunner for JIRA is installed.

Question: With which JQL query do we get all childs from an Initiative (INIT-1) up to all Sub-tasks?

Accepted answers

Fazila Ashraf

Hi @Per Wilhelm

I do not have a DC setup to test this but could you try below to fetch the children of initiative ABC-1 and the subtasks and see if it helps.

issueFunction in portfolioChildrenOf('key=ABC-1') or (issueFunction in subtasksOf("issueFunction in portfolioChildrenOf('key=ABC-1')"))

reference -> https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/portfolio#portfoliochildrenof-examples

All comments

Marc -Devoteam-

Hi @Per Wilhelm

This can only be achieved by adding a marketplace app that is able to provide extra JQL options.

Fazila Ashraf

Hey @Per Wilhelm

Try below if ABC-1 is the initiative ticket

issuekey in portfolioChildIssuesOf("ABC-1")

Marc -Devoteam-

Hi @Fazila Ashraf

This is a cloud only function and @Per Wilhelm specified he is on server.

Fazila Ashraf

ah..i missed to notice that.

Thanks @Marc -Devoteam- !

Per Wilhelm

Adaptavist ScriptRunner for JIRA is installed. Sorry for not mentioning that.

Marc -Devoteam-

Hi @Per Wilhelm

JQL: issuekey in childIssuesOf("INT-1")

Per Wilhelm

Thanks for the first part of the answer, but I also need all Sub-taks for the following two structures / hierarchies:

Initiative --> Epic --> Task --> Sub-task
Initiative --> Task --> Sub-task

Fazila Ashraf

Hi @Per Wilhelm

I do not have a DC setup to test this but could you try below to fetch the children of initiative ABC-1 and the subtasks and see if it helps.

issueFunction in portfolioChildrenOf('key=ABC-1') or (issueFunction in subtasksOf("issueFunction in portfolioChildrenOf('key=ABC-1')"))

reference -> https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/portfolio#portfoliochildrenof-examples

Per Wilhelm

Your JQL query

issueFunction in portfolioChildrenOf('key=ABC-1')

does not consider the follwing tasks:

Initiative --> Epic --> Task

and therefore its Sub-tasks are also not taken into account.

If I combine the answers from you and @Marc -Devoteam- I think I get a valid JQL query:

issuekey in ('INIT-1') OR issuekey in childIssuesOf('INIT-1') OR issueFunction in subtasksOf("issuekey in childIssuesOf('INIT-1')")

Another JQL query that outputs the same scope is:

issuekey in ('INIT-1') OR issuekey in childIssuesOf('INIT-1') OR parent in childIssuesOf('INIT-1')

which looks a little 'strange' to me. I would prefer the query above, which is a combination of your two answers.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server