Order of related bugs/information displayed

[jelv]

Using 0.19.2 - I have created a couple of admin bugs to hold all the bugs to be fixed for a release (as is done on here for the mantisbt project - see http://bugs.mantisbt.org/view.php?id=4181 for an example).

Two questions relating to the grid of relationships:

1. Is it possible to add the priority to the columns displayed.

2. Is it possible to specify a sort order for the related bugs (clickable column headings would be nice). I would like them in priority order.

I actually have two admin bugs - one for "must be fixed before release", the second for "would prefer if these were fixed" - it is the second I would like to prioritise - without having to have more admin bugs.

[jelv]

Well I've managed to hack the sort order. In core/relationship_api.php I replaced the query in function relationship_get_all_src with:

Code: Select all

$query = "SELECT $t_mantis_bug_relationship_table.id, $t_mantis_bug_relationship_table.relationship_type,
				$t_mantis_bug_relationship_table.source_bug_id, $t_mantis_bug_relationship_table.destination_bug_id,
				$t_mantis_bug_table.project_id, $t_mantis_bug_table.priority
				FROM $t_mantis_bug_relationship_table
				INNER JOIN $t_mantis_bug_table ON $t_mantis_bug_relationship_table.destination_bug_id = $t_mantis_bug_table.id
				WHERE source_bug_id='$c_src_bug_id'
				ORDER BY relationship_type, $t_mantis_bug_table.priority DESC, 
					$t_mantis_bug_relationship_table.destination_bug_id";

This now sorts the table in to relationship type, descending priority, bug_id (present order is relationship type, order relationship was added).

I've looked but I'm totally stumped for how to go about adding the priority to the display (I understand SQL but I'm not a php programmer). Can anyone help?

[thraxisp]

Could you add this as a feature request in the tracker at http://bugs.mantisbt.org/ ?

[jelv]

Done: http://bugs.mantisbt.org/view.php?id=5580

(Please correct the category & severity if I haven't got these right)