Versions Compared

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: portfolioChildOf()

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 portfolioParentOf("resolution = "Won't Do" AND status = Closed")

Searches for parents 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 portfolioParentOf("resolution = \"Won't Do\" AND status = Closed")

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

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

Searches for parents of in progress issues reporter by me




SyntaxportfolioParentOf(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 parent issues of issues in a certain status::

Code Block
languagesql
themeConfluence
issue in portfolioParentOf("status = 'To Do'")


• Find all Initiatives of unresolved Epics you might use:

Code Block
languagesql
themeConfluence
issue IN portfolioParentOf("type = Epic AND resolution IS EMPTY") and type = Initiative

• Find 'Themes' that have no 'Initiative' children:

Code Block
languagesql
themeConfluence
issue NOT IN portfolioParentOf("type = Initiative") AND type = Theme

Real World Use Cases:

· Search for Portfolio Parent issues without any Child issues (by Thomas Nielsen 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