Search for Advanced Roadmaps custom fields 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 work items from parent work items: 

  "Parent Link" = EX-001

• Get the child work items from multiple Parent Links: 

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

• Find all work items with no Parent Link:

  "Parent Link" IS EMPTY

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

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

• Get the child work items from multiple Parent Links:

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

JQL function returning work item keys

No

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

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

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

  workitemkey in portfolioChildworkitemsOf("INIT-001")

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

  workitemkey in portfolioChildworkitemsOf("INIT-001") AND workType = Story

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

  workitemkey in portfolioChildworkitemsOf("INIT-001") AND workType != 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 work items assigned to a team:

  "Team" = "shared team name"

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

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

  • Find all work items 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: 

    workitemKey = IOS-76 and "Team" IS EMPTY

  • Find all work items with no team assigned:

    "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 work items with target start after 2 Jan 2020:

• Find all work items with target start before current timestamp:

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

• Find all work items without a target end date: