diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2020-07-29 15:19:58 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2020-07-31 12:24:31 +0100 |
| commit | 34dd7c253d337ea922049390dc6ba44b8686e516 (patch) | |
| tree | 959c5532695ff01ea33f138ece1e7337220501a1 | |
| parent | 5bef5a64577601c01f875264911a882b7794ebca (diff) | |
Prefetch user bodies in admin user search.
| -rw-r--r-- | perllib/FixMyStreet/App/Controller/Admin/Users.pm | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Admin/Users.pm b/perllib/FixMyStreet/App/Controller/Admin/Users.pm index c73f1429b..9fd4cd32d 100644 --- a/perllib/FixMyStreet/App/Controller/Admin/Users.pm +++ b/perllib/FixMyStreet/App/Controller/Admin/Users.pm @@ -64,7 +64,7 @@ sub index :Path : Args(0) { -or => [ email => { ilike => $isearch }, phone => { ilike => $isearch }, - name => { ilike => $isearch }, + 'me.name' => { ilike => $isearch }, from_body => $search_n, ] } @@ -87,7 +87,10 @@ sub index :Path : Args(0) { $users = $users->search({ from_body => { '!=', undef } }); } - $users = $users->search(undef, { order_by => [ \"name = ''", 'name' ] }); + $users = $users->search(undef, { + prefetch => 'from_body', + order_by => [ \"me.name = ''", 'me.name' ], + }); my @users = $users->all; $c->stash->{users} = \@users; if ($search) { |