Reporting Stories without Test Stories

Follow

Comments

4 comments

  • Avatar
    Suzie Prince

    Hi there


    If I understand your query correctly you want to find cards that are NOT associated with a test case is that correct? And you have a tree where Test Case is related to Story, is that correct?


    If so, you can do this by filtering for cards that have the appropriate tree relationship properties as not set. What this means is that each tree has relationship properties between each level of the tree. In your tree you have Test Case and Story. If you want to find out which ones of these do not have a relationship you can filter for the relationship where it is not set. To read more about trees please see here: http://www.thoughtworks-studios.com/mingle/3.0/help/working_with_card_trees.html


    Please let me know if this helps.


    - Suzie

  • Avatar
    Bill Rinko-gay

    Suzie,


    I am using version 2_3_1 Revision 14492.  When I do an Excel export of the stories I can see the relationship 'Test to Story' is set to 'yes'.  However, I can't set a filter that will retrieve these stories.  I've tried 'Test to Story' = 'yes' and 'Test to Story' = TRUE and 'Test to Story' IS NOT NULL.  All give syntax errors.  Can you point to help?


    Thanks,


    Bill

  • Avatar
    Suzie Prince

    Bill


    You can use a MQL query FROM TREE "Tree name" where type = story to retrieve all stories in that tree. This functionality is described here: http://www.thoughtworks-studios.com/mingle/2.3.1/help/mql_reference.html.


    You can also find cards where the value for a property is not (not set) by using the MQL query "card relationship" != (not set).


    I hope this helps.


    - Suzie

  • Avatar
    Michael Decleene

    Another option that may have some side benefits for you is to set up an aggregate property on your stories that is the count of the number of tests associated to that story.  You can then filter on that aggregate property using MQL or other means. 


    To set up an aggregate, go to the tree view, click "Configure" and select "Edit Aggregate Properties."  You want to set aggregates on type "Story."  Define an aggregate called something like "Number of Tests" aggregated as "Count" on scope "Story."  This will act like just another numeric property on your stories, so you can write a filter where "Number of Tests = 0"


    The nice thing about using the aggregate is that you can also do stuff like find the average number of tests for stories, find stories with only one test, or find stories with a crazy number of tests, etc.

Please sign in to leave a comment.