Context: We're using Mingle to track all the User Tasks from a User/Task Analysis for one of our projects (for another project, we've done the same with project Deliverables). The way we've done this is to create a card type "User Task" (with properties like Criticality, Frequency, Primary User Profile, and a flag as whether or not the User Task was in our project's SOW). And then create a "Task" tree where "User Task" is the parent card and "Story" is the child card. Then, a wiki page with charts and pivot table queries to show how we're doing (e.g. distribution of Story Estimates across User Task vs Story Status). All that is great - its one of our main views, and one our clients really appreciate seeing - allows us to be very transparent.
Because we started with our user/task analysis, it's fairly complete and now its time to write a lot stories. Via pivot tables (like the one I mentioned above) I can see quickly which User Tasks have Stories, but what I can't easily see are those that don't. I found an old discussion thread titled "[suggestion] Parents and children" but it's pretty dated and didn't have anything for me.
Challenge: I want a view (table query) that shows all the parents of a certain card type without children. See code snippet of a pivot table - the closest I can get to what I want - it shows the count of stories for each User Task (the ones with blank cells are those without children). Yet this yields a pretty long list, and I'm after a more targeted list.
Seems like this should be possible with the tools already provided in Mingle. I read about improved parent-child management in 3.1 release notes, and read the underlying Macro/MQL reference pages, but they're not all that helpful. Any pointers?
conditions: Type = Story
rows: 'User Task'