CiviCRM Community Forums (archive)

We have CiviEvent configured to allow multiple Participants from a single Contact (i.e., one person can sign up for the same event multiple times). The Event search properly shows the multiple Participants, but when we try to export the Participant records, only the first record for each contact shows up in the export set. So, for example, the search results might show two Participant records for the same contact, but the export set will only contain a single row.

This worked in CiviCRM 3.3, (IIRC), but is definitely not working in 3.4, and seems to have been alluded to in this comment from a year ago:
http://forum.civicrm.org/index.php/topic,15711.msg67291.html

Any suggestions?

Thanks,

Robert

I think I can narrow down the problem here, code-wise. What appears to be happening is that the db query is selecting for DISTINCT contact IDs when it performs the query. That should not be done for a Participant export. Tracing this behavior back through the call chain leads to the following lines in CRM/Contact/BAO/Query.php, starting at line 3420:

            // regenerate fromClause since permission might have added tables
            if ( $permission ) {
                //fix for row count in qill (in contribute/membership find)
                if (! $count ) {
                    $this->_useDistinct = true;
                }

That assignment of $this->_useDistinct = true is what causes the bug in a Participant export. Commenting it out causes the Export Participants to run properly -- at least, for this scenario. But I have no idea what other side effects that simple fix might cause in other circumstances. Perhaps someone who's more familiar with this bit of code could comment on what the cleanest fix would be?

Done:

http://issues.civicrm.org/jira/browse/CRM-8572

There seems to be a related problem with the Custom Search titled "Price Set Details for Event Participants" aka "Price Set Export". In the same situation (multiple Participant records per contact), the listing of records displayed on-screen is missing records, but the CSV export file contains all records.