aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/App/Controller/Dashboard.pm
diff options
context:
space:
mode:
authorMatthew Somerville <matthew@mysociety.org>2020-05-07 16:25:45 +0100
committerMatthew Somerville <matthew@mysociety.org>2020-05-07 16:25:45 +0100
commit6fad0a9adccae962664ccd322e4587e1befeee53 (patch)
tree684c4145bdfb92b3a069e2d71c293e9618f31f07 /perllib/FixMyStreet/App/Controller/Dashboard.pm
parent7cd75c95b5b910b44687b3b478bd0eadbf6f0549 (diff)
parent5ce552af2b66613272dc9cfe2d46532e057f44f7 (diff)
Merge branch 'fix-dashboard-report-csv'
Diffstat (limited to 'perllib/FixMyStreet/App/Controller/Dashboard.pm')
-rw-r--r--perllib/FixMyStreet/App/Controller/Dashboard.pm5
1 files changed, 3 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/App/Controller/Dashboard.pm b/perllib/FixMyStreet/App/Controller/Dashboard.pm
index e5a526efc..833d6d6b2 100644
--- a/perllib/FixMyStreet/App/Controller/Dashboard.pm
+++ b/perllib/FixMyStreet/App/Controller/Dashboard.pm
@@ -349,14 +349,15 @@ sub export_as_csv : Private {
my $groups = $c->cobrand->enable_category_groups ? 1 : 0;
my $join = ['comments'];
- my $columns = ['comments.problem_state', 'comments.state', 'comments.confirmed', 'comments.mark_fixed'];
+ my $columns = ['comments.id', 'comments.problem_state', 'comments.state', 'comments.confirmed', 'comments.mark_fixed'];
if ($groups) {
push @$join, 'contact';
- push @$columns, 'contact.extra';
+ push @$columns, 'contact.id', 'contact.extra';
}
my $csv = $c->stash->{csv} = {
objects => $c->stash->{objects_rs}->search_rs({}, {
join => $join,
+ collapse => 1,
'+columns' => $columns,
order_by => ['me.confirmed', 'me.id'],
cursor_page_size => 1000,