From 72aeb6b9a70f89699793efc4eca3f771cd0b2a02 Mon Sep 17 00:00:00 2001 From: Matthew Somerville Date: Fri, 17 Aug 2012 18:40:02 +0100 Subject: Speed up this type of search by a factor of c. 10e5. Stupid databases. --- perllib/FixMyStreet/App/Controller/Admin.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'perllib/FixMyStreet/App/Controller/Admin.pm') 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 = []; -- cgit v1.2.3