I'm trying my first MQL query, something I can put in a story description to show the # of tasks for a story that are not finished yet. I didn't find a lot of examples of value queries in the manual, so was trying something like this
value query: SELECT 'Task count' WHERE 'Story' = 'THIS CARD'where task count is the aggregate property on the relationship between story and task. The next step would be adding another piece of the where clause to say something like 'type = task and status != fixed'
As is though, this returns 0, despite the fact that the actual aggregate property in this card clearly says 4.
What am I missing?
Comments
2 comments
Not sure if aggregate properties are directly queryable (someone official can comment on that). But I'd hope you can get the same answer by doing something like this:
{{
value query: SELECT COUNT(*) WHERE Type = Task AND Status != Fixed AND Story = THIS CARD
}}
That did it, thanks!
Please sign in to leave a comment.