Searching for Portfolio for Jira custom fields in JQL

Plan

On this page

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

You can use Jira Query Language (JQL) to search for issues that use custom issue fields in Portfolio. To search for issues using JQL, follow these steps:

  1.  In Jira, go to > Search for issues > Advance search bar.
  2. Enter the search query as explained in the cases below and click Enter.

To learn more about advanced searching in Jira, see Advanced searching.

Parent Link

To search for child issues of an issue in Portfolio using the issue's Parent Link:

Syntax
"Parent Link"
Alias
cf[CustomFieldID]
Field TypeParent Link relationship
Auto-completeNo
Supported operators
IS,IS NOT,=,!=,IN,NOT IN
Unsupported operators
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
Examples

  • Get the list of child issues from parent issues: 

     "Parent Link" = EX-001

  • Get the child issues from multiple Parent Links: 

    "Parent Link" IN (EX-000, EX-001, EX-002, EX-003)

  • Find all issues with no Parent Link:

    "Parent Link" IS EMPTY

  • Find all issues that have either EX-001 set as a parent or don't have a parent.

     "Parent Link" IN (EX-001, EMPTY)

  • Get the child issues from multiple Parent Links:

    "Parent Link" IN (EX-000, EX-001, EX-002, EX-003)

Child issues

To search for child issues of an issue:

Syntax
"Portfolio Child Issues"
Field TypeportfolioChildIssuesOf
Auto-completeNo
Supported operators
IS,IS NOT,=,!=,IN,NOT IN
Unsupported operators
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
Examples

  • To get all child issues below INIT-00 and not just the child issues at the epic hierarchy level:

     issuekey in portfolioChildIssuesOf("INIT-001")

  • if you want to return just the story-level issues: 

    issuekey in portfolioChildIssuesOf("INIT-001") AND issueType != Epic

  • If needed, you can skip returning issues of the hierarchy levels you don't need:

    issuekey in portfolioChildIssuesOf("INIT-001") AND issueType != Epic.



Team field

To search for issues, including subtasks, using the Team custom field or an issue in Portfolio using the issue's Parent Link.

Syntax
Team
Alias
cf[CustomFieldID]
Field typeText Field
Auto-complete

Yes

Note: Selecting the shared team name from the auto-suggested list of team names will replace the actual name of the team in the query with its numerical ID. For example:

Team = MyTeam → "Team = 3


Supported operators
IS,IS NOT,=,!=,IN,NOT IN
Unsupported operators
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
Examples

    • Get the list of issues assigned to a team:

      Team = "shared team name"

    • Get the list of issues assigned to any set of teams type: 

      Team IN ("Shared team 1", "Shared team 2", "Shared team 3")

    • Find all issues in the "iOS app development" project that don't have a team assigned:

        project = iOS app development and Team IS EMPTY.

    • Find all stories in the "IOS-76" epic that don't have a team assigned: 

      issueKey = IOS-76 and Team IS EMPTY.

    • Find all issues with no team assigned:

      Team IS EMPTY




Last modified on Jan 15, 2019

Was this helpful?

Yes
No
Provide feedback about this article

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.