Skip to content

[bug] exception when downloading report with options #1253

Description

@compwron

This should download a valid report.

Screen Shot 2020-11-04 at 10 52 52 PM

BugsnagAPP  10:52 PM
New unhandled error in staging from casa in case_contact_reports#index (details)
Unhandled error
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR:  column "casa_cases.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...nt" AS t0_r10, "case_contacts"."notes" AS t0_r11, "casa_case...
                                                            ^
Location
app/models/case_contact_report.rb:24 - block in to_csv
10:52
Event in staging from casa in case_contact_reports#index (details)
Unhandled error
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR:  column "casa_cases.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...nt" AS t0_r10, "case_contacts"."notes" AS t0_r11, "casa_case...
                                                            ^
Location
app/models/case_contact_report.rb:24 - block in to_csv
New
10:53
Event in staging from casa in case_contact_reports#index (details)
Unhandled error
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR:  column "casa_cases.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...nt" AS t0_r10, "case_contacts"."notes" AS t0_r11, "casa_case...
                                                            ^
Location
app/models/case_contact_report.rb:24 - block in to_csv

https://app.bugsnag.com/ruby-for-good/casa/errors/5fa3a12e0919bf0017c1a806?event_id=5fa3a12e00622b4d15640000&i=sk&m=nw

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions