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 | 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$)
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")
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$
| iQies PI numbers and start datesPI 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: 2022-7-20 (2022-07-20, 2022-10-11)
| EQRS PIs: Start Dates and Ranges 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: 2022-4-13 (2022-04-13, 2022-07-05)
PI 19: 2022-7-6 (2022-07-06, 2022-09-27)
| iQies Statuses: (note: a value with multiple words needs "qoutes") Funnel"Feature Definition""Feature Refinement""Feature Deep Dive""Story Definition""PI Ready"Implementing
| EQRS Feature Statuses:Funnel"Analyzing (SAFe)"RefiningReady For PIImplementing
| iQIES Team Project Keys: "iQIES Enigma", "iQIES HCD", "iQIES Frontiers", "iQIES Bohemian Rhapsody (DevOps)", "iQIES Dune (CLIA)", "iQIES FACT (Data and Backend)", "iQIES Outlander", "iQIES PA Reports", "iQIES QMIR Data", "iQIES SAS Viya / Dashboards", "iQIES S&C Reports", "IQIES SNOOPY", "iQIES Stargate", "iQIES Immeasurable", "iQIES The Misfits", "iQIES The Shop", "IQIES Woodstock" | EQRS Team Project Keys: EQRS, EQRSCI, EQRSD, EQRSARCH, EQRSEDSM, EQRSONBRD, EQRSMD, EQRSMS, EQRSPRTL |
|