aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2012-02-28 10:41:03 +0000
committerMatthew Somerville <matthew@mysociety.org>2012-02-28 10:41:03 +0000
commitf3b817bef7c55a1c601c6ce5a67f146dd855240c (patch)
tree07b7fb5ce07038c54a371ed454a1677b28b85afd
parent179aaa5852127e7d26b246816b69984b4ecf3468 (diff)
Reports page wants to know if photo exists.
-rw-r--r--perllib/FixMyStreet/App/Controller/Reports.pm1
1 files changed, 1 insertions, 0 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Reports.pm b/perllib/FixMyStreet/App/Controller/Reports.pm
index 0587a627a..5305b23b4 100644
--- a/perllib/FixMyStreet/App/Controller/Reports.pm
+++ b/perllib/FixMyStreet/App/Controller/Reports.pm
@@ -343,6 +343,7 @@ sub load_and_group_problems : Private {
'id', 'council', 'state', 'areas', 'latitude', 'longitude', 'title', 'cobrand',
{ duration => { extract => "epoch from current_timestamp-lastupdate" } },
{ age => { extract => "epoch from current_timestamp-confirmed" } },
+ { photo => 'photo is not null' },
],
order_by => { -desc => 'lastupdate' },
rows => 100,