Searching for Portfolio for Jira custom fields in JQL

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

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:

構文
"Parent Link"
エイリアス
cf[CustomFieldID]
フィールド タイプ Parent Link relationship
オートコンプリート いいえ
サポートされる演算子
IS,IS NOT,=,!=,IN,NOT IN
サポートされない演算子
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
  • 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:

構文
"Portfolio Child Issues"
フィールド タイプ portfolioChildIssuesOf
オートコンプリート いいえ
サポートされる演算子
IS,IS NOT,=,!=,IN,NOT IN
サポートされない演算子
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
  • 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.

構文
チーム
エイリアス
cf[CustomFieldID]
Field type Text Field
オートコンプリート

はい

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


サポートされる演算子
IS,IS NOT,=,!=,IN,NOT IN
サポートされない演算子
~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED
Supported Keywords
EMPTY
    • 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




最終更新日 2019 年 1 月 15 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.