Search for custom fields from plans in JQL

Parent Link relationship

No

IS,IS NOT,=,!=,IN,NOT IN

~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED

• Get the list of child issues from parent issues: 

  1 "Parent Link" = EX-001

• Get the child issues from multiple Parent Links: 

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

• Find all issues with no Parent Link:

  1 "Parent Link" IS EMPTY

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

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

• Get the child issues from multiple Parent Links:

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

JQL function returning issue keys

No

IS,IS NOT,=,!=,IN,NOT IN

~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED

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

  1 issuekey in portfolioChildIssuesOf("INIT-001")

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

  1 issuekey in portfolioChildIssuesOf("INIT-001") AND issueType = Story

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

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

Team Field

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:

IS,IS NOT,=,!=,IN,NOT IN

~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED

• Get the list of issues assigned to a team:

  1 "Team" = "shared team name"

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

    1 "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:

    1 project = iOS app development and "Team" IS EMPTY

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

    1 issueKey = IOS-76 and "Team" IS EMPTY

  • Find all issues with no team assigned:

    1 "Team" IS EMPTY

Target Date Field

Yes

Note: The auto-suggested list contains JQL functions that returns date-time values where the function name matches the user supplied text. For example:

=, !=, NOT IN, IN, IS NOT, IS, >, >=, <, <=

~,!~,>,>=,<,<=
WAS,WAS IN,WAS NOT,WAS NOT IN,CHANGED

• Find all issues with target start after 2 Jan 2020:

• Find all issues with target start before current timestamp:

• Find all issues with target end earlier than 5 days ago:

• Find all issues without a target end date: