Filter only tiddlers with a tag, where other tiddlers are tagged with their title

[Bastian]

Hi all,

I'm trying to create a project overview with projects that have open tasks.
The current system has tiddlers that are tagged "project" which defines them as a project.
A task is another tiddler, that has the projects title as a tag and additionally the tag "task" assigned to them.

I'd like to achieve an overview with a list of only the projects, that have open tasks, but I can't get it to work.

This lists me all open projects:

[tag[project]!status[done]!status[REJECTED]!status[ONHOLD]sort[]]

and this lists me all open tasks under the list of the projects:

[!has[draft.of]tag[task]tag<currentTiddler>!status[done]!status[REJECTED]] [enlist{!!aliases}tagging[]tag[task]!status[done]!status[REJECTED]]

What I can't get to work is that I only want to be list the projects that have open tasks, and not every project.

I tried to filter for tiddlers with the tag task and the currentTiddler in the tag but that just gave me an empty result.

Can someone point me in the right direction what the first filter expression would have to look like?

[Charlie Veniot]

G'day,

Silly question:  is the status field on project tiddlers, or is the status field on task tiddlers?

[si]

Try this:

[tag[task]!field:status[done]tags[]tag[project]]

I'm assuming that you are using a "status" field to indicate that a task is complete.

[Bastian]

The status field is on both of them as I use to keep track of the projects status and tasks status with the same set. Works for me, it's not that detailed, rather more like "open, in work, done" and a few extra status likerejected or onhold.

[Bastian]

hmm, nah, doesn't work (zero results).
I'm going to fiddle around with your suggestions a little, maybe I can get it to work.

I already got a list of all projects (first filter expression from my inital post) with their tasks underneath (second filter expression).

Now what I would need to do is to adapt the first filter expression so it only selects projects that have open tasks.

So as far as I understood your filter expression it filters all tasks with tag[task], excludes done tasks with !field:status[done], which is correct and then the magic happens in tags[]tag[project], correct?
I'm currently just not sure on how I would have to combin it, to filter only projects with open tasks, as the filter alone isn't giving me any results yet :/

[si]

I just did a quick test and it seemed to work as I expected:

tag[task] - lists all tasks

!field:status[done] - filters that list down to only open tasks

tags[] - lists all the tags of those open tasks

tag[projects] - identifies which of those tags represent projects

That should give you all projects that have open tasks. Maybe there is a capitalization error, e.g. "done" vs "Done"?

[Bastian]

Dang! Yes! I had a typo in there, thanks a lot for your help! Works just as intended, what a wonderful overview :-)

[Charlie Veniot]

Sometimes, a solution just needs some "sounding boards", and I always find that a very cool thing.

Good job!