View Issue Details

IDProjectCategoryView StatusLast Update
0003880mantisbtfilterspublic2004-08-29 02:35
ReporterMark Ingram Assigned ToNarcissus  
PrioritynormalSeveritytweakReproducibilityalways
Status closedResolutionfixed 
Fixed in Version0.19.0rc1 
Summary0003880: Ordering doesnt take last_updated into account
Description

When ordering by other columns such as priority it doesnt take into account the last updated or the bug added date. When ordering by highest priority, top priorities are at top, but then when the rest that have no priority are listed, they appear in a random order. Would be nice to have them in date order too.

TagsNo tags attached.
Attached Files
filter_api.zip (4,441 bytes)

Activities

Mark Ingram

Mark Ingram

2004-05-26 06:07

reporter   ~0005592

Fixed this problem by adding the following lines into filter_api.php:

$query2 .= " ORDER BY '$c_sort' $c_dir";

Mark Ingram

    # 26/05/04
    # Added this if statement to always show most recently updated bugs at top
    # followed by the most recently added bugs

if ( $c_sort != "last_updated" ) {
$query2 .= ", last_updated DESC, date_submitted DESC";
}
else {
$query2 .= ", date_submitted DESC";
}