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?