Mantis Bug Tracker - Forums

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

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

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

Alex

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

What information exactly you'd like to present?

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: