diff options
author | Joe Siltberg <git@joesiltberg.se> | 2019-02-25 09:47:33 +0100 |
---|---|---|
committer | Matthew Somerville <matthew-github@dracos.co.uk> | 2019-02-25 10:08:07 +0000 |
commit | b9e1b1384b11acbd5d9fd51e92eb7278fb6eb43d (patch) | |
tree | 4c4890be9d46081440b0f1df8a1a094d19f61d26 | |
parent | f582e71e03d8d661768b8f977107a87e6bd2d2b8 (diff) |
Filters out hidden reports from top 5 list.
-rw-r--r-- | perllib/FixMyStreet/DB/Result/Body.pm | 1 |
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' }, |