Exporting bug notes

goodybytes · Post by **goodybytes** » 19 Apr 2005, 12:36

Hi,
How do you export bugs with a given criteria i.e. status of confirmed and include the bug notes in the export?

Would this require some work?

GB

Guest · Post by **Guest** » 20 Apr 2005, 16:10

I did a query that got our bug notes per bug id, however, my mySQL skills are somewhat limited in a rush.

The following query works to an exetent. It does NOT give us all the bug notes for a given bug but just the 1st one...any ideas?

SELECT mantis_bugnote_table.bug_id, mantis_bug_table.status, mantis_bugnote_text_table.note, mantis_bug_table.project_id
FROM mantis_bugnote_table, mantis_bug_table, mantis_bugnote_text_table
WHERE (
mantis_bug_table.id = mantis_bugnote_table.bug_id
AND mantis_bugnote_table.bugnote_text_id = mantis_bugnote_text_table.id
)
AND (
mantis_bug_table.project_id =51
AND mantis_bug_table.status =40
)

Post by **vboctor** » 21 Apr 2005, 11:44

Is there a reason why you don't want to use bugnote_get_all_bugnotes() from core/bugnote_api.php?

Regards,
Victor
MantisConnect
http://www.futureware.biz/mantisconnect/

Guest · Post by **Guest** » 25 Apr 2005, 12:55

Hi,
Not having direct access to the back end of Mantis (apart from the phpMyAdmin), I don't have the joy of going in there and figuring this out.

How can our administrators achieve searching on a given criteria and then exporting the bugnotes using what you have described?

:: bugnote_get_all_bugnotes() from core/bugnote_api.php ::

Regards,
BG