Mantis Bug Tracker - Forums

Hello again,
well I've pondered the thought for quite some time now, but I can't think of a good and easy solution to solve this. Maybe one here can help me?

The situation is as follows. There are several departments, let's call them A, B and C. Every department has its own instance of Mantis that is used for everyday work. What I want to do now is to search data from all these instances of Mantis and make it possible to display them in a single view, without having to log on to each instance. What would be a possible and maybe the easiest way to accomplish this without changing the frontend or core-files?

1.) Is it possible to create another Mantis instance as "Meta-Mantis", which collects and stores the data from the others?
2.) Would it be possible to create a webservice which directs search queries from one Mantis instance to another one and displays the return value of the search it has performed? Does Mantis support any interfaces for a solution like this?

My greatest thanks in advance for any help on this solution!

FAIK, Mantis may not provide this sort of thing right out of the box per se, but there are a number of ways to do this. One is to create an application that pulls a report from each database then performs a collation.

Under the hood, you could write the SQL necessary to read the desired data, then write this to a special table, perhaps a temporary table, adding a key value for the source database. Do this for each of the databases. Once the table is populated another set of SQL statements coupled with some presentation tool, such as PHP, can be used to create a final report.

hth,

- Mophilly

Just what I imagined. Thanks again!
I'm off to implement.