),
),
);
+ $this->_columns['civicrm_mailing_group'] = array(
+ 'dao' => 'CRM_Mailing_DAO_MailingGroup',
+ 'filters' => array(
+ 'entity_id' => array(
+ 'title' => ts('Groups Included in Mailing'),
+ 'operatorType' => CRM_Report_Form::OP_MULTISELECT,
+ 'type' => CRM_Utils_Type::T_INT,
+ 'options' => CRM_Core_PseudoConstant::group(),
+ ),
+ ),
+ );
$config = CRM_Core_Config::singleton();
$this->campaignEnabled = in_array("CiviCampaign", $config->enableComponents);
if ($this->campaignEnabled) {
LEFT JOIN civicrm_mailing_event_unsubscribe mailing_event_optout_civireport
ON mailing_event_optout_civireport.event_queue_id = {$this->_aliases['civicrm_mailing_event_queue']}.id AND mailing_event_optout_civireport.org_unsubscribe = 1";
+ if ($this->isTableSelected('civicrm_mailing_group')) {
+ $this->_from .= "
+ LEFT JOIN civicrm_mailing_group {$this->_aliases['civicrm_mailing_group']}
+ ON {$this->_aliases['civicrm_mailing_group']}.mailing_id = {$this->_aliases['civicrm_mailing']}.id";
+ }
if ($this->campaignEnabled) {
$this->_from .= "
LEFT JOIN civicrm_campaign {$this->_aliases['civicrm_campaign']}