LACE (CCSQ Lean Agile Center of Excellence)

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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 VariablesQueries by Report

iQIES
Program Project Key: IQIESPB 

EQRS
Program Project Key: EQRS

Current Program Backlog Composition


Current Program Backlog Health

Project = "$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 Dates

Project = $Program Project Key$ AND issuetype = EPIC AND Status was "$Feature Status$" on ($PI Start Date$)

All Art Teams Backlog composition by PI

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

Project 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
  • 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: 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)"
  • Refining
  • Ready For PI
  • Implementing

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

  • No labels