External Reporting

[apienaar]

Hi All,

I am very new to Mantis although the company where I am working is not and I am struggling a bit. I would like to write an external script (php or even asp), that will query the Mantis MySQL database. I want to create an external web interface that can tap into the database and present data how I would like to have it arranged, displayed, etc. I do not want to write to the database, I simply would like to extract data. I have created custom fields and cannot get a handle on the values of these fields, it all seems a bit abstract.

If anyone can help me in this regard, it will be greatly appreciated. Thank you for your time and effort.

Regards,

Alex

[alexl]

Do you have the access to the Mantis installation? or all you have is the database access?

[apienaar]

Hi,

Thank you for your speedy reply. Yes, I have access to all the installation files. I also forgot to mention that I am using Mantis version 1.1.1.

Kind Regards,

Alex

[alexl]

Alex

Then I suggest not writing an "external" script, but modifying the existing views.

What information exactly you'd like to present?

[aCCuReRaS]

I'd like such report too.

I've created a custom field.
In this field we place object id's, separated by a comma and each number has a prefix letter (5 different prefixes).

What report do I want:
for all issues related to a specified version, I want to display the object id's per issue, and the different prefixes in separated columns.

Example:

Code: Select all

 
Release 1.2.4.5
Object id's for Issue 102:
T         R         C          D         F  
45001     23000     12003      34567     33298                  
23546               77322      90012     33211       

Object id's for Issue 114:
T         R         C          D         F  
13324     77643     22365      00932     33298                  
66543               11234      99754