Author Topic: How to filter list of mailings by mailing group? [SOLVED] (Read 856 times)

davyivins · July 07, 2012, 09:59:06 am

Is it possible to filter a View of Mailings by the mailing group the mail was sent to? I have CiviCRM integration working but can't find a field for Mailing Group.

Donald Lobo · July 07, 2012, 03:39:51 pm

not part of the views integration code right now, but might not be too hard to do so.

The mail part of the code is here:

drupal/modules/views/components/civicrm.mail.inc

would be great if you can investigate and help add the include / exclude groups and mailing columns.

lobo

davyivins · July 07, 2012, 05:49:44 pm

Hi Lobo - I can't find the file you referred to - is this the one? drupal/modules/views/civicrm.views.inc

Sadly the more I looked at the code the more I remembered that I have absolutely no coding experience :-)
That said I'll have a wild / blind stab at it and see if I get lucky.

But if there's anyone else out there who actually knows what they're doing and has some time on their hands (I know I know..) I'd real appreciate the help.

davyivins · July 07, 2012, 06:45:43 pm

I did it !!

Added the following in the mailing section of drupal/modules/views/civicrm.views.inc (I added it after line 4679)

Code: [Select]



  //Mailing GROUP table
  $data['civicrm_mailing_group']['table']['group'] = ts('CiviCRM Mailing Group');

  $data['civicrm_mailing_group']['table']['join'] = array(
    // link to civicrm_mailing
    'civicrm_mailing' => array(
      'left_field' => 'id',
      'field' => 'mailing_id',
    ),
  );

  // What group did the mailing go to
  $data['civicrm_mailing_group']['entity_id'] = array(
    'title' => t('Mailing Group'),
    'help' => t('What mailing group was the mailing sent to'),
    'field' => array(
      'handler' => 'views_handler_field',
      'click sortable' => TRUE,
    ),
    'argument' => array(
      'handler' => 'views_handler_argument',
    ),
    'filter' => array(
      'handler' => 'views_handler_filter_string',
      'allow empty' => TRUE,
    ),
    'sort' => array(
      'handler' => 'views_handler_sort',
    ),
  );

CiviCRM Community Forums (archive)

News:

Author Topic: How to filter list of mailings by mailing group? [SOLVED] (Read 856 times)

davyivins

How to filter list of mailings by mailing group? [SOLVED]

Donald Lobo

Re: How to filter list of mailings by mailing group?

davyivins

Re: How to filter list of mailings by mailing group?

davyivins

Re: How to filter list of mailings by mailing group?