/
portfolioChildOf()

portfolioChildOf()

Owned by Jack Nolddor
Last updated: Nov 23, 2019

Description:

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.

 Let's see an example...

(error) This will not work

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

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"

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 installed 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::

issue in portfolioChildOf("status = 'To Do'") and issuetype = Initiative

• Find child issues of Initiatives and their associated Stories

issue IN portfolioChildOf("type = Initiative") OR issue IN issuesInEpics("issue IN portfolioChildOf('type = Initiative')")

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

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

Related content