diff options
| -rw-r--r-- | perllib/FixMyStreet/App/Controller/Admin.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Admin.pm b/perllib/FixMyStreet/App/Controller/Admin.pm index 65b24f238..e9c9b6174 100644 --- a/perllib/FixMyStreet/App/Controller/Admin.pm +++ b/perllib/FixMyStreet/App/Controller/Admin.pm @@ -231,7 +231,7 @@ sub reports : Path('reports') { } } - my $order = $c->get_param('o') || 'created'; + my $order = $c->get_param('o') || 'id'; my $dir = defined $c->get_param('d') ? $c->get_param('d') : 1; $c->stash->{order} = $order; $c->stash->{dir} = $dir; @@ -302,7 +302,7 @@ sub reports : Path('reports') { { prefetch => 'user', rows => 50, - order_by => [ \"(state='hidden')", $order ] + order_by => $order, } )->page( $p_page ); @@ -345,7 +345,7 @@ sub reports : Path('reports') { -select => [ 'me.*', qw/problem.bodies_str problem.state/ ], prefetch => [qw/user problem/], rows => 50, - order_by => [ \"(me.state='hidden')", \"(problem.state='hidden')", { -desc => 'me.created' } ] + order_by => { -desc => 'me.id' } } )->page( $u_page ); $c->stash->{updates} = [ $updates->all ]; |