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.
Query Variables | Queries by Report | |
iQIES | EQRS Program Project Key: EQRS | Current Program Backlog CompositionCurrent 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 statusesView 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 dates
| EQRS PIs: Start Dates and Ranges
| |
iQies Statuses: (note: a value with multiple words needs "qoutes")
| EQRS Feature Statuses:
| |
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 |