aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/App/Controller/Admin.pm
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2012-08-17 18:40:02 +0100
committerMatthew Somerville <matthew@mysociety.org>2012-08-17 18:40:02 +0100
commit72aeb6b9a70f89699793efc4eca3f771cd0b2a02 (patch)
treeb46ff13d5a15cfc6c9228c176e76f8e8f9975a92 /perllib/FixMyStreet/App/Controller/Admin.pm
parent6592b1b101593b2b14a127380c6635fb2f84222a (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.pm2
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 = [];