Lybunt report - improve developer support for debugging this report
authoreileen <emcnaughton@wikimedia.org>
Wed, 14 Nov 2018 02:13:05 +0000 (15:13 +1300)
committereileen <emcnaughton@wikimedia.org>
Fri, 16 Nov 2018 06:49:42 +0000 (19:49 +1300)
commitf0197a3d0be92152413807b97b1aafb2e765fe2e
treeafe715c0bd4113d3c863e05ff1403f7dbebd6120
parent67c07fa1d4e7bc663018befa125ce4b1441294d0
Lybunt report - improve developer support for debugging this report

By using the createTemporaryTable to create our temporaray table we
help developers out by
a) adding the query to the developer tab
b) supporting CIVICRM_TEMP_FORCE_DURABLE
(see debugging section in dev docs)

This fix updates a function used by reports that have been marked with

groupFilterNotOptimised = FALSE

The reports with optimised group filtering construct a temp table
of contacts in the groups & use those to inner join / limit
the contacts in the report.

They are tested via a bunch of tests in api_v3_ReportTemplateTest such as

testReportsWithNonSmartGroupFilter

m

Change-Id: I1102b43a643760320a4b011c7a11146c8d4f380f
CRM/Report/Form.php
CRM/Report/Form/Contribute/Lybunt.php
CRM/Utils/SQL/TempTable.php