List on a story card

Follow

Comments

8 comments

  • Avatar
    Suzie Prince

    Hi Lisa


    Can you share your macro syntax? This will help us diagnose the issue.


    As reference here is a similar table that produces a list of stories in an iteration and is displayed on the iteration card.


    {{
      table
        query: SELECT number, name, status, 'closed on', 'pre-release estimate' WHERE type = story and iteration = THIS CARD order by status, name
    }}


    Thanks


    - Suzie

  • Avatar
    Lisa

    Hi,


    I've tried the most obvious (and some more far fetching)


    {{
       table
          query: SELECT number, name WHERE type = Defect AND Story = THIS CARD
    }}


    /Lisa (still confused)

  • Avatar
    Lisa

    Perhaps I should add the most common error message I got "Error in table macro using xx project: Card property 'Story' does not exist!"
    /Lisa

  • Avatar
    Huimin Li

    Hi Lisa:


     


    The error message you provided makes suspect that "story" is not a available property for "defect". 


     


    Can you check whether "story" is a property for "defect"?   If you open a defect card, on the card properties section, you should be able to see all the available properties. 


     


    How do you associate your defect to the story? If you are using tree, what is the name of the relationship property?


     


    Thanks.


     


    -- Huimin

  • Avatar
    Lisa

    Hi Huimin,


    I've got a tree with a relationship name 'release11 - Story', so association is via the tree. (The tree is simple Story>Defect.)
    We doesn't have a story property on the defect cards (so the error message is not unexpected).


    Thanks
    /Lisa

  • Avatar
    Huimin Li

    Hi Lisa:


    I guess the association is via the tree relationship "release 11 - Story", You can try:


    {{
       table
          query: SELECT number, name WHERE type = Defect AND "release11 - Story" = THIS CARD
    }}


    -- Huimin

  • Avatar
    Lisa

    Hi Huimin!
    Super thank you!
    Now I'll spread the word to all my projects Smile
    /Lisa

  • Avatar
    Huimin Li

    You are always welcome! Smile

Please sign in to leave a comment.