View Issue Details

IDProjectCategoryView StatusLast Update
0027490mantisbtperformancepublic2020-11-25 14:20
Reporternicklin Assigned Todregad  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionno change required 
Product Version2.24.3 
Summary0027490: Number of times the problem was reassigned
Description

I need a function.
Reassign Times / Issue: The number of times each issue has been reassigned the person in charge.
It is possible that a problem will be kicked around like a ball, causing the problem to not be solved in a reasonable time, so the number of times the problem changes hands can also be regarded as an indicator of ability.

TagsNo tags attached.

Activities

nicklin

nicklin

2020-11-10 01:25

reporter   ~0064620

Last edited: 2020-11-10 01:25

I can execute script on the database.
Script↓
SELECT mantis_bug_table.project_id, mantis_bug_history_table.bug_id, count(*) handler_count , mantis_bug_table.status FROM mantis_bug_history_table
JOIN mantis_bug_table
ON mantis_bug_history_table.bug_id = mantis_bug_table.bug_text_id
WHERE mantis_bug_history_table.field_name = 'handler_id'
AND mantis_bug_history_table.old_value <> mantis_bug_history_table.new_value
AND mantis_bug_table.status <> 80
AND mantis_bug_table.status <> 90
GROUP BY bug_id

mantis_bug_table.PNG (36,179 bytes)   
mantis_bug_table.PNG (36,179 bytes)   
nicklin

nicklin

2020-11-10 01:28

reporter   ~0064621

How do I present on Mantis?
Result

Result.PNG (34,522 bytes)   
Result.PNG (34,522 bytes)   
wutsdis

wutsdis

2020-11-10 07:36

reporter   ~0064622

Maybe you could do a custom function and add it from a custom field? I'm not very good at modding the system, so you could read more in the links. It is sometimes very hard to do simple things like that in mantis or perhaps you have to know how the whole thing works, which is not great. A plug-in could be another way to do it, but can't help you there either.
https://www.mantisbt.org/docs/master/en-US/Admin_Guide/html/admin.customize.customfuncs.html
https://www.mantisbt.org/docs/master/en-US/Admin_Guide/html/admin.customize.html

dregad

dregad

2020-11-11 11:20

developer   ~0064640

IMO the easiest way to do this would definitely be with a plugin.

Look at the EVENT_FILTER_COLUMNS and define a custom class derived from MantisColumn. As an example, you can look at how the Source Integration plugin does it
https://github.com/mantisbt-plugins/source-integration/blob/master/Source/classes/RelatedChangesetsColumn.class.php

This is not a bug or feature request for MantisBT (you are asking for help on how to customize the system). I am therefore resolving this issue as "no change required".

Please use the forums to get support on customizing and using MantisBT (refer to http://www.mantisbt.org/support.php for links and further details).

nicklin

nicklin

2020-11-12 20:10

reporter   ~0064646

Thanks, I can try it.