LACE (CCSQ Lean Agile Center of Excellence)

Page tree

Versions Compared

Old Version 10

changes.mady.by.user Marc Santini

Saved on

compared with

New Version 11

changes.mady.by.user Marc Santini

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

These variables can be used to in validation queries to check PI's, Program Reports and Aggregated Teams Reports

See previous validation results.

...

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

iQIES
Program Project Key: IQIESPB 

EQRS
Program Project Key: EQRS

Current Program Backlog Composition


Current Program Backlog Health


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


...