Versions Compared

Old Version 3

changes.mady.by.user Jack Nolddor

Saved on

compared with

New Version 4

changes.mady.by.user Jack Nolddor

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Description:

Excerpt

Returns child issues (on Portfolio hierarchy) of issues specified by the provided subquery.
See also: portfolioParentOf()

Note:
Since you need to enclose the provided subquery using doble quotes, you must to escape any doble quotes using in the subquery by preceding a backslash after the double quotes, alternatively you can use a single quote in some cases.

Expand
titleLet's see an example...


Panel

(error) This will not work

Code Block
languagesql
themeConfluence
issue IN portfolioChildOf("resolution = "Won't Do" AND status = Closed")

Searches for childrens of already closed issues which their resolution have been set to "Won't Do"



(tick) This will work perfectly

Code Block
languagesql
themeConfluence
issue IN portfolioChildOf("resolution = \"Won't Do\" AND status = Closed")

Searches for childrens of already closed issues which their resolution have been set to "Won't Do"

Code Block
languagesql
themeConfluence
issue IN portfolioChildOf("status = 'In Progress' AND reporter = currentUser()")

Searches for childrens of in progress issues reporter by me


(warning) This function does not traverse the link from Epic to Story. To also search for stories, or subtasks you should use this function in conjuntion with issuesInEpics() or subtasksOf() JQL functions.


SyntaxportfolioChildOf(subquery)
Available sincev2.0.0-RELEASE
Only if Portfolio for Jira is present on the system.
Supported fieldsIssue
Supported operatorsIN , NOT IN
Unsupported operators

= , != , ~ , !~ , > , >= , < , <=

IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find all 'Initiatives' that belong to issues in a certain status::

Code Block
languagesql
themeConfluence
issue in portfolioChildOf("status = 'To Do'") and issuetype = Initiative


• Find child issues of Initiatives and their associated Stories

Code Block
languagesql
themeConfluence
issue IN portfolioChildOf("type = Initiative") OR issue IN issuesInEpics("issue IN portfolioChildOf('type = Initiative')")

• Find 'Initiatives' that don't belong to Themes:

Code Block
languagesql
themeConfluence
issue not in portfolioChildOf("type = Theme") and issuetype = Initiative

Real World Use Cases:

· JQL query to find child issues of Initiative (by Thomas Nielsen at ATLASSIAN Community)
· JQL for Initiatives and child epics in Portfolio (by Elrich Strydom at ATLASSIAN Community)
· How to give a JQL subquery inside ParentIssuesOf or ChildIssuesOf (by Filipe Nascimento at ATLASSIAN Community)




JQL Function Reference

Page Tree
rootJQL Function Reference
startDepth2