Jira Filter usage

Extended Jira Filters here: Search extensions

Name	JQL	Used for

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 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