Author Topic: <solved>In custom report, specialized SQL is not used for "Export CSV" (Read 1014 times)

SarahG (FountainTribe) · March 12, 2014, 04:42:14 pm

I have written a custom report which overrides the function buildQuery( ) to create a very specialized SQL select statement. This works fine when the end-user is viewing the results. However, the custom SQL is NOT used when the user clicks "Export CSV" and so they get different results in the CSV file than they see on the screen.

Any ideas on how to get the "Export CSV" button/action to use the SQL that I create in the function "buildQuery"

Erik Hommel · March 13, 2014, 01:27:33 am

Do you store your sql in the class variable ($this->sql)?

SarahG (FountainTribe) · March 13, 2014, 06:34:28 am

Yes, I do have the line " $this->sql" in my buildQuery() function.

Erik Hommel · March 13, 2014, 06:58:47 am

You need to check the export CSV function CRM_Report_Utils_Report::export2csv($this, $rows)

SarahG (FountainTribe) · March 13, 2014, 08:45:27 am

Thanks for the help everyone. The export to CSV was calling my custom SQL. The problem existed elsewhere in the code

CiviCRM Community Forums (archive)

News:

Author Topic: <solved>In custom report, specialized SQL is not used for "Export CSV" (Read 1014 times)

SarahG (FountainTribe)

<solved>In custom report, specialized SQL is not used for "Export CSV"

Erik Hommel

Re: In custom report, specialized SQL is not used for "Export CSV"

SarahG (FountainTribe)

Re: In custom report, specialized SQL is not used for "Export CSV"

Erik Hommel

Re: In custom report, specialized SQL is not used for "Export CSV"

SarahG (FountainTribe)

<solved> In custom report, specialized SQL is not used for "Export CSV"