diff options
author | Matthew Somerville <matthew@mysociety.org> | 2012-08-17 18:40:02 +0100 |
---|---|---|
committer | Matthew Somerville <matthew@mysociety.org> | 2012-08-17 18:40:02 +0100 |
commit | 72aeb6b9a70f89699793efc4eca3f771cd0b2a02 (patch) | |
tree | b46ff13d5a15cfc6c9228c176e76f8e8f9975a92 /perllib/FixMyStreet/App/Controller/Admin.pm | |
parent | 6592b1b101593b2b14a127380c6635fb2f84222a (diff) |
Speed up this type of search by a factor of c. 10e5. Stupid databases.
Diffstat (limited to 'perllib/FixMyStreet/App/Controller/Admin.pm')
-rw-r--r-- | perllib/FixMyStreet/App/Controller/Admin.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Admin.pm b/perllib/FixMyStreet/App/Controller/Admin.pm index 4de3d0d1e..298c75352 100644 --- a/perllib/FixMyStreet/App/Controller/Admin.pm +++ b/perllib/FixMyStreet/App/Controller/Admin.pm @@ -536,7 +536,7 @@ sub search_reports : Path('search_reports') { } elsif ($search =~ /^id:(\d+)$/) { $query = [ 'me.id' => int($1), - 'problem.id' => int($1), + 'me.problem_id' => int($1), ]; } elsif ($search =~ /^area:(\d+)$/) { $query = []; |