Can a table query pull data from different trees

Follow

Comments

8 comments

  • Avatar
    Mansi Shah

    Hi Kim,


    You could directly retrieve data from the Story card without specifying which Tree it belongs to. Please try the below example to query the mingle number, name, status and estimate of all the story cards in a particular iteration.


    {{ table query: SELECT number, name, 'Story Status',  'Planning Estimate' WHERE 'type' = 'story' and 'Iteration' = THIS CARD}}


    For the second example you provided, you are selecting number from one tree and name from another, if the card is of a particular card type, irrespective of which tree it belongs to, you could directly query it in the format provided above.


    Please refer to the 'Table - based on a query' section in the following link: http://www.thoughtworks-studios.com/mingle/3.3/help/macro_reference.html


    Hope this helps! Do let me know if you need any further clarification.


    -Mansi

  • Avatar
    Unknown_User

    Thanks Mansi,


    I already have the following table query working on a card in my tree 'Planning tree - story'.


    {{
     table query: SELECT number, name, 'story status', 'planning estimate' WHERE 'Team' = 'Stream 2' AND 'type' = 'story' AND 'Sprint' = (Next Sprint)
    }}


    I need to include data from another tree both of which have the story card. I've tried to include the item from the other tree as you've suggested (see below) and whilst the table column appears the data is not being pulled through.



    {{
     table query: SELECT number, 'CR number', name, 'story status', 'planning estimate' WHERE 'Team' = 'Stream 2' AND 'type' = 'story' AND 'Sprint' = (Next Sprint)
    }}


    Any further help would be greatly appreciated.


    Kim

  • Avatar
    Mansi Shah

    Hi Kim,


    Is the 'CR number' property on the Story card? If the property is not on the Story card, there will be no data to display in the table.

  • Avatar
    Unknown_User

    Hi Mansi,


    No the 'CR number' is on the Business Proposal card in the BP tree.


    That is why I'm trying to pull data from different trees.


    Is there a way of including two trees in a table query OR another way of relating trees?


    Kim

  • Avatar
    Mansi Shah

    Hi Kim,


    Apologies for the delay in my response. Could you please provide your exact tree structure for the BP tree.

  • Avatar
    Unknown_User

    Hi Suzie,


    Angela asked me to post my tree configurations.


    Planning tree - story  Release > Sprint > Story > Defect > Task > Tech Debt > Spike


    BP tree  BP > Story


    I'm writing a query from the Planning tree - story and trying to pull additional data from the BP tree.


    Kim

  • Avatar
    Mansi Shah

    Hi Kim,


    As of the current release of Mingle, you will not be able to select the CR value from the BP card while querying data from the Story card on the Planning tree -  story. 


    What you could do currently is use the NESTED IN clause to get is a list of all the stories with a particular CR number or a list of stories with their parent BP stories. 


    We have captured your scenario as a feature request.


    Thanks!


    Mansi

  • Avatar
    Unknown_User

    Thanks for looking into this Mansi.


    Kim

Please sign in to leave a comment.