Agenda that shows hierarchy above matches?

[Tilmann Singer <tils@tils.net>]

Hi,

I wonder if there is way to get an agenda showing all TODO items with
the hierarchical context up to the top level.

Given an projects.org like this:

 * Project A
 ** TODO do foo
 ** TODO do bar
 ** DONE do baz
 * Project B
 ** DONE do foo
 * TODO Another small thing

An agenda view, e.g. tags match for /!TODO looks like this:

 projects: TODO do foo
 projects: TODO do bar
 projects: TODO Another small thing

In order to find out the context of the first two lines, I currently
have to go to each line and hit tab to see the corresponding location
in the org file or switch on follow mode. This is not ideal for
getting an overview over all TODO items when there are lots of such
matches because I would then need to follow each item and remember the
context. Also sometimes I would like to export an agenda to a text
file including all their parent headlines up to the top level, but no
other items of the org file.

So is there a way to get an agenda that looks similar to this:

 projects: 
 * Project A
 ** TODO do foo
 ** TODO do bar
 * TODO Another small thing

Actually org-sparse-tree is very close to what I want, but first it
only works for a single org file (which I could live with), but also
as far as I see there is no way to hide the collapsed top level
headlines which have no match - "* Project B" in the above example.


Til