aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJoe Siltberg <git@joesiltberg.se>2019-02-25 09:47:33 +0100
committerMatthew Somerville <matthew-github@dracos.co.uk>2019-02-25 10:08:07 +0000
commitb9e1b1384b11acbd5d9fd51e92eb7278fb6eb43d (patch)
tree4c4890be9d46081440b0f1df8a1a094d19f61d26
parentf582e71e03d8d661768b8f977107a87e6bd2d2b8 (diff)
Filters out hidden reports from top 5 list.
-rw-r--r--perllib/FixMyStreet/DB/Result/Body.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/perllib/FixMyStreet/DB/Result/Body.pm b/perllib/FixMyStreet/DB/Result/Body.pm
index cccb1ddf3..3c013378c 100644
--- a/perllib/FixMyStreet/DB/Result/Body.pm
+++ b/perllib/FixMyStreet/DB/Result/Body.pm
@@ -215,6 +215,7 @@ sub calculate_average {
],
'me.id' => \"= ($substmt)",
'me.state' => 'confirmed',
+ 'problem.state' => [ FixMyStreet::DB::Result::Problem->visible_states() ],
}, {
select => [
{ extract => "epoch from me.confirmed-problem.confirmed", -as => 'time' },