[Trac] querying across projects

[Neil Gower]

I started poking around with WikiMacros to try to generate a list of 
tickets across several projects.  The projects are all hosted on the 
same server, as described here:

http://projects.edgewall.com/trac/wiki/TracMultipleProjects

I know I'm fighting the system a bit here, since each Trac project is 
really independent of the others.  However, given that I control all of 
the projects, it seems like I should be able to set up db connections to 
each of the databases, and aggregate the data in the macro.

I'm hoping someone could jump start the process a bit by helping me 
figure out how to set up those connections from within a macro.

Any tips are much appreciated!

Cheers,


Neil.