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', Owner
WHERE ((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?