CiviCRM Community Forums (archive)

When multiple contacts are updated at the same time, the logging detail for a single event shows data for multiple events. I was able to replicate this issue on the demo site.

I made an update to two contacts and the following two rows appeared in the Contact Logging Report (Summary) http://i.imgur.com/w4h7AX8.png

The Contact Logging Report (Details) for each of the events are http://i.imgur.com/xXboiKx.png and http://i.imgur.com/HGi55mf.png
You can see on the second link that is shows the details for both events.

The SQL that selects the contact ids for the report is:

SELECT DISTINCT lt.id FROM `log_table` lt
 
WHERE log_conn_id = %1 AND
      log_date BETWEEN DATE_SUB(%2, INTERVAL 10 SECOND) AND DATE_ADD(%2, INTERVAL 10 SECOND)
The query is only based on connection id and log date. Since multiple updates at the same time with have the same connection id and will occur within +/- 10 seconds, multiple contact ids are selected.

An additional where clause can be generated if the contact id is passed but the following code never seems to pull a value:

$this->cid         = CRM_Utils_Request::retrieve('cid', 'Integer', CRM_Core_DAO::$_nullObject);

I had to alter $params because it was causing an issue with the Contribution Logging Report (Detail)

    $params = array(
      1 => array($this->log_conn_id, 'Integer'),
      2 => array($this->log_date, 'String'),
    );
   
    if(CRM_Utils_Array::value('title', $this->_params) !== 'Contribution Logging Report (Detail)'){
    $params[3] = array($this->cid, 'Integer');
    } else {
    $this->log_date = str_replace( array('-', ':', ' ') , '', $this->log_date);
    }