Time calculation on tickets

[antonio.cardinale]

Hi all guys,

I need to create some export, and I see that I can download CSV files.
But there is a way to have the time spent on a single ticket (from open to solved)?
If you need more info let me know
Thanks

[cas]

in the bug_history table you will find timestamps for each status. These will allow you to calculate the total time between registering and solving.

[antonio.cardinale]

eheheh thank you, and I know it.
Hope there is a way to download a report whit the bug history at this point, but with all reports, or in a certain time range.

[cas]

not quite sure what you mean.
You can create the query yourself in phpmyadmin or even better, create a small plugin.

[antonio.cardinale]

Ok, I'll try to be more clear
We (my company) are trying to certificate for quality (ISO27001) and we need a lot of documentation.
One of these is about our tshoot on our customers service requests on Mantis.
What we need exactly is to export the time spent in tshoot every single request and print it in a report.
Do you think there is already a way to do it with MantisBT or I need to ask to my developer collegues to create something to do it?

[cas]

No that is not available.
I do have a generic query plugin which allows you to create queries and send reports by mail.
Of course a dedicated plugin could do the job too

[antonio.cardinale]

ooook, thank you so much

[colivarez]

We're very interested in the Query Plugin but it's for Mantis Core 1.2.0. What changes would be needed to allow it to work with Mantis Core 2.0.0 and above?

[cas]

I have attached the version for Mantis 2.X. It is still in validating phase so any help is appreciated.

[rondezo]

I have attached the version for Mantis 2.X. It is still in validating phase so any help is appreciated.

Hello, where can I read how to configure this plugin?

[cas]

Check out the doc-directory within the plugin

[rondezo]

Check out the doc-directory within the plugin

Ths!!!!

[mushu]

We use https://github.com/mantisbt-plugins/timetracking