diff options
| author | Dave Lawrence <dlawrence@mozilla.com> | 2012-08-10 22:41:10 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-08-10 22:41:10 +0200 |
| commit | fa6a04cf74404946ceb71c055c152b7859c5a65a (patch) | |
| tree | f220f0c244b40c1641544232115de46eb04435f0 /extensions/MyDashboard/Extension.pm | |
| parent | b0ffc83036d55ec7e2870de0d8146760185e342f (diff) | |
| download | bugzilla-fa6a04cf74404946ceb71c055c152b7859c5a65a.tar.gz bugzilla-fa6a04cf74404946ceb71c055c152b7859c5a65a.tar.xz | |
small changes to My Dashboard
Diffstat (limited to 'extensions/MyDashboard/Extension.pm')
| -rw-r--r-- | extensions/MyDashboard/Extension.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/extensions/MyDashboard/Extension.pm b/extensions/MyDashboard/Extension.pm index a0a5e36cf..d1bbc17f1 100644 --- a/extensions/MyDashboard/Extension.pm +++ b/extensions/MyDashboard/Extension.pm @@ -170,7 +170,7 @@ sub _standard_saved_queries { my $user = Bugzilla->user; # Default sort order - my $order = ["bug_id"]; + my $order = ["changeddate desc", "bug_id"]; # List of columns that we will be selecting. In the future this should be configurable # Share with buglist.cgi? @@ -257,7 +257,7 @@ sub _flags_requested { attachments.description AS attach_summary, requesters.realname AS requester, requestees.realname AS requestee, - " . $dbh->sql_date_format('flags.creation_date', '%Y.%m.%d %H:%i') . " AS created + " . $dbh->sql_date_format('flags.creation_date', '%Y:%m:%d') . " AS created FROM flags LEFT JOIN attachments ON ($attach_join_clause) @@ -291,7 +291,7 @@ sub _flags_requested { $query .= ") "; # Order the records (within each group). - my $group_order_by = " GROUP BY flags.bug_id ORDER BY flagtypes.name, flags.creation_date"; + my $group_order_by = " GROUP BY flags.bug_id ORDER BY flags.creation_date, flagtypes.name"; my $requestee_list = $dbh->selectall_arrayref($query . " AND requestees.login_name = ? " . |