These variables can be used to in validation queries to check PI's, Program Reports and Aggregated Teams Reports
Note: All Variables are formatted to work in queries as is. Keep Quotes and Commas based on the variables and queries
See previous validation results.
Excerpt |
---|
Query Variables | Queries by Report | iQIES Program Project Key: IQIESPB | EQRS Program Project Key: EQRS | HQR Program Project Key: HQR | Current Program Backlog Composition
Current Program Backlog HealthProject = "$Program Key$ " AND issuetype = 10000 (AND Status = "$Status$") AND Status not in (done, abandoned, "Production Ready", Implementing, Funnel, Blocked, Backlog, Deployed* Used when validating individual statuses
View testing and validation results
Features in Status on PI Start DatesProject = $Program Project Key$ AND issuetype = EPIC AND Status was "$Feature Status$" on ($PI Start Date$)
View testing and validation results
Features started and closed Per PI
View testing and validation results
All Art Teams Backlog composition by PIProject in ($Team Project Keys$) AND issuetype in (Spike, Story, Enabler, Bug) AND created >= $PI Start Date$ AND created <= $PI End Date$ AND status was in (Done, Closed, Done, "Production Ready")
View testing and validation results
All ART Teams Work Delivered by Category by PIProject in ($Team Project Keys$) AND issuetype in(Story, Bug, Spike, Enabler) AND resolutiondate >= $PI Start Date$ AND resolutionDate <= $PI End Date$
View testing and validation results | PI Start Dates and Ranges |
|
Tabs Container |
---|
title | Program Dashboard Validation Queries |
---|
direction | horizontal |
---|
|
Tabs Page |
---|
|
title | PI Start Date Master Validation Query |
---|
|
Excerpt |
---|
Find and bookmark the Jira Query (need instructions)
Change the status, date and project to validate the status of items on a programs on the first day of each of the past 4 PIs, and the current PI
Projects:
iQies
Project Name: IQIESPB (no Quotes)
iQies PI numbers and start dates |
PI 3: 2021-7-7 (2021-07-07, 2021-10-12)PI 4: 2021-10-13 (2021-10-13, 2022-01-18)PI 5: 2022-1-19 (2022-01-19, 2022-04-19)PI 6: 2022-4-20 (2022-04-20, 2022-07-19)PI 7:
|
2202-20 iQies Statuses: (note: a value with multiple words needs "qoutes")
Funnel
Feature Definition
Feature Refinement
Feature Deep Dive
Story Definition
PI Ready
Implementing
EQRS
-20 (2022-07-20, 2022-10-11)PI 8: 2022-7-20 (2022-10-12, 2022-12-20)PI 9: 2022-12-21 (2022-12-21, 2023-03-14)PI 10: 2023-3-15 (2023-03-15, 2023-06-06)PI 11: 2023-6-07 (2023-06-07, 2023-08-29)PI 12: 2023-8-30 (2023-08-30, 2023-11-21)PI 13: 2023-11-22 (2023-11-22, 2024-02-13)
|
EQRS PI numbers and start dates | PI 14: 2021-4-4 (2021-04-04, 2021-07-19)
PI 15: 2021-7-20 (2021-07-20, 2021-10-12)
PI 16: 2021-10-13 (2021-10-12, 2022-01-18)
PI 17: 2022-1-19 (2022-01-19, 2022-04-12)
PI 18:
|
2202-4-13 2022-4-13 (2022-04-13, 2022-07-05)
PI 19: 2022-7-6 (2022-07-06, 2022-09-27)PI 20: 2022-9-28 (2022-09-28, 2022-12-20)PI 21: 2022-12-21 (2022-12-21, 2023-03-14)PI 22: 2023-3-15 (2023-03-15, 2023-06-06)PI 23: 2023-6-07 (2023-06-07, 2023-08-29)PI 24: 2023-8-30 (2023-08-30, 2023-11-21)PI 25: 2023-11-22 (2023-11-22, 2024-02-13)
| PI 18: 2021-08-04 (2021-08-24, 2021-11-15)PI 19: 2021-11-16 (2021-11-16, 2022-02-07)PI 20: 2022-02-08 (2022-02-08, 2022-05-02)PI 21: 2022-05-03 (2022-05-03, 2022-07-25)PI 22: 2022-07-26 (2022-07-26, 2022-10-17)PI 23: 2022-10-18 (2022-10-18, 2023-01-09)PI 24: 2023-1-10 (2023-01-10, 2023-04-03)PI 25: 2023-4-4 (2023-04-04, 2023-06-26)PI 26: 2023-6-27 (2023-06-27, 2023-09-18)PI 27: 2023-9-19 (2023-09-19, 2023-12-11)PI 28: 2023-12-12 (2023-12-12, 2024-03-04)
|
Feature Statuses (note: a value with multiple words needs "qoutes") |
Funnel"Feature Definition""Feature Refinement""Feature Deep Dive""Story Definition""PI Ready"Implementing
Pasteable query string: Funnel, "Feature Definition", "Feature Refinement","Feature Deep Dive","Story Definition","PI Ready",Implementing | |
Funnel
Analyzing (SAFe)
RefiningReady For PIImplementing
Pasteable query string: Funnel,"Analyzing (SAFe)", Refining,"Ready for PI", Implementing | Funnel"Refinement Backlog""Ready for Refinement""Analyzing Safe""Story Definition""PI Ready"Implementing
Pasteable query string: Funnel,"Refinement Backlog","Ready for Refinement","Analyzing Safe","Story Definition","PI Ready",Implementing |
Team Project Keys |
IQIESRHAP, IQIESDUNE, IQIESPAEN, IQIESFACT, IQIESFRT, IQIESHCD, IQIESMCS, IQIESOUT, IQIESPAR, IQIESPB, IQIESQMIRD, IQIESSCR, IQIESSVD, IQIESNOOP, IQIESSTG, IQIESPATM, IQIESSHOP, IQIESWOOD | EQRS, EQRSCI, EQRSD, EQRSARCH, EQRSEDSM, EQRSONBRD, EQRSMD, EQRSMS, EQRSPRTL |
HQRPP |