Time calculation on tickets

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
antonio.cardinale
Posts: 5
Joined: 10 Jul 2019, 13:49

Time calculation on tickets

Post 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
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Time calculation on tickets

Post 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:
antonio.cardinale
Posts: 5
Joined: 10 Jul 2019, 13:49

Re: Time calculation on tickets

Post 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.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Time calculation on tickets

Post by cas »

not quite sure what you mean.
You can create the query yourself in phpmyadmin or even better, create a small plugin.
antonio.cardinale
Posts: 5
Joined: 10 Jul 2019, 13:49

Re: Time calculation on tickets

Post 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?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Time calculation on tickets

Post 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:
antonio.cardinale
Posts: 5
Joined: 10 Jul 2019, 13:49

Re: Time calculation on tickets

Post by antonio.cardinale »

ooook, thank you so much
colivarez
Posts: 16
Joined: 03 Feb 2020, 20:38

Re: Time calculation on tickets

Post 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?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Time calculation on tickets

Post by cas »

I have attached the version for Mantis 2.X. It is still in validating phase so any help is appreciated. :mrgreen:
Attachments
Query202.zip
(66.71 KiB) Downloaded 477 times
rondezo
Posts: 85
Joined: 09 Feb 2021, 09:18

Re: Time calculation on tickets

Post 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?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Time calculation on tickets

Post by cas »

Check out the doc-directory within the plugin :mrgreen:
rondezo
Posts: 85
Joined: 09 Feb 2021, 09:18

Re: Time calculation on tickets

Post by rondezo »

cas wrote: 10 Nov 2021, 07:28 Check out the doc-directory within the plugin :mrgreen:
Ths!!!!
Post Reply