Attachment 314222 Details for Bug 458987 – patch to remove the sortorder1 section

[patch] patch to remove the sortorder1 section

drop_kbase_sorting.patch (text/plain), 1.43 KB, created by Rob Landry on 2008-08-13 16:50:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Rob Landry

Created: 2008-08-13 16:50:38 UTC

Size: 1.43 KB

patch

obsolete

>Index: list.cgi
>===================================================================
>RCS file: /cvs/qa/hwcert/list.cgi,v
>retrieving revision 1.25
>diff -u -r1.25 list.cgi
>--- list.cgi	21 Jul 2008 06:11:05 -0000	1.25
>+++ list.cgi	13 Aug 2008 16:37:08 -0000
>@@ -631,7 +631,7 @@
> # $main_query .= " ORDER BY $db_order " if ($order);
> 
> # Put the clean certs first, then order by Vendor/Make/Model.
>-$main_query .= " ORDER BY sortorder0, cf_devel_whiteboard, sortorder1, status_whiteboard, 
>+$main_query .= " ORDER BY sortorder0, cf_devel_whiteboard, status_whiteboard, 
>                           cf_qa_whiteboard, version DESC, cf_fixed_in ";
> 
> # Form query for next list of results;
>Index: Bugzilla/Search.pm
>===================================================================
>RCS file: /cvs/qa/hwcert/Bugzilla/Search.pm,v
>retrieving revision 1.10
>diff -u -r1.10 Search.pm
>--- Bugzilla/Search.pm	21 Jul 2008 06:17:04 -0000	1.10
>+++ Bugzilla/Search.pm	13 Aug 2008 16:37:08 -0000
>@@ -1166,8 +1166,6 @@
> 
>     $query .= " , (CASE WHEN cf_internal_whiteboard = 'Component/Peripheral' THEN 1 ELSE 0 END) as sortorder0 "; 
> 
>-    $query .= " , (CASE WHEN ext_bz_bug_id IS NULL THEN 0 ELSE 1 END) as sortorder1 "; 
>-
>     $query .= " FROM bugs LEFT JOIN parent_bugs ON bugs.bug_id = parent_bugs.bug_id " .
>               " LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id " .
>               " LEFT JOIN ext_bz_bug_map ON ext_bz_bug_map.bug_id = bugs.bug_id ";

Actions: View | Diff

Attachments on bug 458987: 314222