Aggregating defects in a release (across mutiple sprints)

Follow

Comments

4 comments

  • Avatar
    Jay Mitchell

    If you were just using the sprint parent property in the tree then this would be fairly straightforward because you could also reference the release tree property. You would just need this query:


    SELECT count(*) WHERE type=defect and 'tree - release' = THIS CARD.'tree - release'


    Since you have 'Defect Fix Completed in Sprint' and 'Defect Reported in Sprint' this is still possible, but a little more complicated:


    SELECT count(*) WHERE type=defect AND 'Defect Fix Completed in Sprint' IN (SELECT number WHERE type=sprint AND 'tree - release' = THIS CARD.'tree - release')


    This uses two MQL features - THIS CARD.property and the beta nested IN feature. Because you are on the sprint card, you can reference THIS CARD.'tree - release' (or whatever the name of the release property is on the sprint) to get the sprint's release. You can then find all the sprints with that release (sprints 1-3) and use those sprints as the values for the defect's 'Defect Fix Completed in Sprint' property.

  • Avatar
    Unknown_User

    Thanks Jay.


    We tried the expression suggested with our release property substituted:


    {{ value query: SELECT COUNT (*) WHERE 'Team' = 'Stream 2' AND type=defect AND 'Defect Fix Completed in Sprint' IN (SELECT number WHERE type=sprint AND 'release tree - release' = THIS CARD.'release tree - release')}}


    However this is giving an error:


    Error in value macro using Which? Digital Team project: Card property 'release tree - release' does not exist!


    I have attached a screenshot of our release property.


    Any further help would be much appreciated (just about to go on leave for a couple of weeks so I my not pick up any response straight away).


    Thanks.


    Kim



  • Avatar
    Jay Mitchell

    The name of the property is a bit cut off in the screenshot, but it looks like the release property name is just, "release". You don't want to prefix it with the tree name. My example made that a little confusing.

  • Avatar
    Unknown_User

    Thanks Jay. I've just picked this up again, amended the code regarding your last comment and got it working.


    Kim

Please sign in to leave a comment.