We have a Release card with linked Story cards, each with linked Task cards. The release card has the following MQL query for the “Tasks and Stories” section:
h3. Tasks and Stories
table query: SELECT Number, Type, Name, Project_1, Status, 'SC Numbers', OwnerWHERE ((Type = Story OR Type = Task) AND Release = THIS CARD)
ORDER BY Story ASC
We were hoping this would group the story and the tasks that go with it. No luck. The tasks for a story are all together, but the story is not with them. Do you know of a better way to do the query to get more of a hierarchical result?
Thanks!!
Table Query with Grouping
Comments
1 comment
I've added this to the Mingle backlog.
One unofficial workaround, to at least get a link to these cards, is to embedd a value macro inside of a link to the hierarchy view. For example,
http://your_mingle_instance/mingle/projects/your_project/cards/hierarchy?tf_release[]=[Release][is][{{value
query: SELECT number WHERE number=THIS CARD.number
}}]&tree_name=Planning+tree
gives a link to a page that includes the cards in the release card you are on.
To build this, I went to the hierarchy view, filtered by a release card, and configured the view the way I wanted to see it (e.g., you might want to add type, project_1, status, etc. properties to your view). Once I did this, I clicked, "link to this page." I copied the URL, and then replaced the reference to the release number in the URL to the value query.
Please sign in to leave a comment.