Page 1 of 1

Time calculation on tickets

Posted: 22 Apr 2021, 08:07
by 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

Re: Time calculation on tickets

Posted: 23 Apr 2021, 12:26
by 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. :mrgreen:

Re: Time calculation on tickets

Posted: 23 Apr 2021, 12:50
by 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.

Re: Time calculation on tickets

Posted: 23 Apr 2021, 13:10
by cas
not quite sure what you mean.
You can create the query yourself in phpmyadmin or even better, create a small plugin.

Re: Time calculation on tickets

Posted: 23 Apr 2021, 13:18
by 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?

Re: Time calculation on tickets

Posted: 23 Apr 2021, 14:42
by 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 :mrgreen:

Re: Time calculation on tickets

Posted: 23 Apr 2021, 14:50
by antonio.cardinale
ooook, thank you so much

Re: Time calculation on tickets

Posted: 28 Oct 2021, 04:10
by 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?

Re: Time calculation on tickets

Posted: 28 Oct 2021, 08:02
by cas
I have attached the version for Mantis 2.X. It is still in validating phase so any help is appreciated. :mrgreen:

Re: Time calculation on tickets

Posted: 10 Nov 2021, 07:08
by rondezo
cas wrote: 28 Oct 2021, 08:02 I have attached the version for Mantis 2.X. It is still in validating phase so any help is appreciated. :mrgreen:
Hello, where can I read how to configure this plugin?

Re: Time calculation on tickets

Posted: 10 Nov 2021, 07:28
by cas
Check out the doc-directory within the plugin :mrgreen:

Re: Time calculation on tickets

Posted: 17 Nov 2021, 05:52
by rondezo
cas wrote: 10 Nov 2021, 07:28 Check out the doc-directory within the plugin :mrgreen:
Ths!!!!

Re: Time calculation on tickets

Posted: 23 Nov 2021, 18:24
by mushu