Hello,
We have realized the following (possible) structure / hierachy in our JIRA:
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?
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')"))
Your JQL query
issueFunction in portfolioChildrenOf('key=ABC-1')
does not consider the follwing tasks:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey @Per Wilhelm
Try below if ABC-1 is the initiative ticket
issuekey in portfolioChildIssuesOf("ABC-1")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a cloud only function and @Per Wilhelm specified he is on server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Per Wilhelm
This can only be achieved by adding a marketplace app that is able to provide extra JQL options.
Like
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Adaptavist ScriptRunner for JIRA is installed. Sorry for not mentioning that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Per Wilhelm
JQL: issuekey in childIssuesOf("INT-1")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the first part of the answer, but I also need all Sub-taks for the following two structures / hierarchies:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Per Wilhelm
So I assume you have 2 different structures with both it's own hierarchy.
If I look at the structure documentation, you should be able to use:
issue in structure("your structureName", INT-1)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The term structure was perhaps misleading. I mean the following hierarchy in JIRA. For the Sub-tasks on the lowest level I would still need the JQL query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.