Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Name

JQL

Used for

NSP- Cards assigned to Epics in Quarter [Housekeeping]

Project = NSSP and issuekey in childrenOfIssuesInQuery("'Team[Team]' = 3 and issuetype = Epic and 'Delivery Period' = FY24Q1")

Find all children of Epics earmarked for a specific Delivery Period in NSSP Project for a specific Team.

Use to update children with delivery period or Release after QPE or general housekeeping: I have stopped relying on delivery period for anything other than Epics, thus only update the release.

REMEMBER: Change the quarter and the team name before execution

NSP - All Epics Current Quarter

project = NSSP AND issuetype = Epic AND "Delivery Period[Dropdown]" = FY24Q1

Find all NSP Epics for the quarter specified. This is used in reporting on epic level.

Each Quarter: Change the quarter

NSP - All Open Epics

project = NSSP AND issuetype = Epic and status != Done

Find all the open NSP Epics. This is used in reporting on epic level - Showing WIP and pipeline.

NSP - GIS Network Migration

issuekey in portfolioChildIssuesOf(NSSP-1635) ORDER BY issuetype, Rank

Everything under the hierarchy of the “Network Migration” Program Epic

DPG - Cards assigned to Epics in Quarter [Housekeeping]

project = NHVRREP AND issuekey in childrenOfIssuesInQuery("'Team[Team]' = 8 and issuetype = Epic and 'Delivery Period' = FY24Q1")

Find all children of Epics earmarked for a specific Delivery Period in NHVRREP Project for a specific Team.

Use to update children with delivery period or Release after QPE or general housekeeping: I have stopped relying on delivery period for anything other than Epics, thus only update the release.

REMEMBER: Change the quarter and the team name before execution

DPG - All Epics Current Quarter

project = NHVRREP AND issuetype = Epic AND "Delivery Period[Dropdown]" = FY24Q1

Find all DPG Epics for the quarter specified. This is used in reporting on epic level.

Each Quarter: Change the quarter

DPG - All Open Epics

project = NHVRREP AND issuetype = Epic and status != Done

Find all the open DPG Epics. This is used in reporting on epic level - Showing WIP and pipeline.

DPG-WF FY24Q2 All work for quarter

project = NHVRREP AND issuekey in childrenOfIssuesInQuery("'Team[Team]' = 8 and issuetype = Epic and 'Delivery Period' = FY24Q21")

All work for the specific quarter, assigned to a specific team.

This is an improvement on the “DPG - FY24Q1 - Portal all work” filters above, because it does not rely on the team to supply delivery period for all cards. Only the Epics need the reads down the hierarchy for Epics in the specific delivery period.

A few uses:

  • Update the FixVersion of all cards to that specific release after QPE

  • “Exception report” on which new cards have not been tagged with the release

  • Export the filter records to be used in the manual Epic progress report

DPG-DP FY24Q2 All work for quarter

project = NHVRREP AND issuekey in childrenOfIssuesInQuery("'Team[Team]' = 8 and issuetype = Epic and 'Delivery Period' = FY24Q2")

NSP-SP FY24Q2 All work for quarter

Project = NSSP and issuekey in childrenOfIssuesInQuery("'Team[Team]' = 3 and issuetype = Epic and 'Delivery Period' = FY24Q2")

NSP-GIS FY24Q2 All work for quarter

Project = NSSP and issuekey in childrenOfIssuesInQuery("'Team[Team]' = 9 and issuetype = Epic and 'Delivery Period' = FY24Q2")

NSP - VIC outstanding work GIS

filter = "NSP - VIC outstanding work GIS"

This filter reads the hierarchy of all work for the VIC Program Epics

...