Hi Experts -
Another syntax question for you... This time I want to have a list of all the cards where the planned iteration is in the past. What I would like to do is get the "end date" value of the iteration card that is assigned to the story using a planning iteration tree. I have seen some similar posts talking about getting parent properties for children cards, but most are talking about queries on card descriptions not wikis using "This card" or PROPERTY. Any thoughts? I pasted some code that doesn't work, but has the idea of what I am trying to do. Hopefully, I just have the syntax wrong, thanks.
Code Snippet
table query: SELECT number WHERE 'Planning Tree - Iteration'.'end date' < TODAY
Comments
6 comments
Scot, I am not aware of a query syntax that will let you reference a relationship of property on a related card of differnt type, but i think the following snippet may give you what you want by comparing the story card's iteration with a project variable (current iteration) to give a list of open stories that are past their planned iteration.
{{ table query: SELECT name,number WHERE Type =story AND 'Story Status' <'Awaiting sign off' and iteration < (Current iteration)}}
I tried that, but it says:
Comparing between property ‘Planning Tree – Iteration’ and project variable (Current Iteration) is invalid as they are not associated with each other
Any thoughts?
Awesome, I totally missed that, thanks! It works perfectly now.
Hi Scott:
Right now there is no mql syntax supported by Mingle to query child cards directly by property of their parents. However we do have story planned to support this, and hopefully it will come soon. We will let you know when it is available.
Thanks.
Hi All,
We have added a beta feature to get children cards based on properties of parent cards in Mingle 3.3. This is rather technically referred to as "nested IN."
Scot, If I understand your post correctly, your table query would be something like:
Note: I have split the query over multiple lines for readability. The query should be on a single line in Mingle.
Thanks,
Jay
Please sign in to leave a comment.