Bug history

Question

I would like to query the history of a bug/issue ID to determine where the bottleneck is

I need to see Created, Deployed & Closed dates for each bug/issue ID.  When I utilize the basic filters I am not able to retrieve all the required statuses

I would like to see how many days from the time a bug is created to the time the vendor deploys a fix.  Then, how many days it takes our team takes to close from the deployed date

Tim Reiking · Answer

Hi Matt,

I'm a developer/consultant at cPrime that works with our Power Apps. One of our apps (Power Custom Fields Premium) would be great to help you solve this issue.

Once installed you could create a new custom field of type SIL Script Custom Field. The field will then execute a script each time the ticket is loaded to display desired information. The script is added to the field's configuration and written cPrime's Simple Issue Language (SIL).

For example I have written a quick example script for a field called Time to Resolve:

interval diff = resolutionDate - created;
return diff;

This code will get the created date and the resolution date from the current ticket and display the difference between them using a SIL interval object.

Example return value: 2d 13h 43m

The result will be displayed in both the search results view and the ticket view:

If you have a date that comes from a custom field, you can refer to that field using the following syntax:

interval diff = customfield_11000 - created;
return diff;

For more information on getting ticket values, see Variable Resolution.

I hope that this helps you. Please reach out if you need any additional information.

Thanks,
Tim

Lime Trees · Answer

Hi,

you can have a look at our Status History add-on where you can check all status and user changes - more details here.

If you need to analyze the data, Status History PRO and its viewer will be a great help.

Regards,

Lime Trees Support Team

Matt MacNichol · Answer

thanks for the help