CiviCRM Community Forums (archive)

This is a possible feature request and a note for others who may want to go down this path.  If there's a better/easier way to do this, I'd love to know it.

Using Views to generate a list of participants, I want to show all participants along with their primary contact information (address, phone, email).  I found however, that by default views shows all the contact info - so both home and billing emails for example.   You can't just use views to filter "is_primary= false" because then if a contact doesn't happen to have any email at all their participation is completely filtered out.

Instead I modified the joins to bring in only the primary contact information in the first place.  Specifically, in civicrm.core.inc I added "'extra' => 'civicrm_phone.is_primary=1'" in each relevant place, for example ...

  //CiviCRM Phone Using Contacts as a pitstop before going on to Participants
  $data['civicrm_phone']['table']['join']['civicrm_participant'] = array(
    'left_table' => 'civicrm_contact
    'left_field' => 'id',
    'field' => 'contact_id',
    'table' => 'civicrm_phone',
    'extra' => 'civicrm_phone.is_primary=1'
  );


Unfortunately, I couldn't get this to work out of the box with views (I'm in drupal 7, views 3, civicrm 4.4.5).   This could very well be something I'm doing wrong with the syntax of the 'extra' line, but the only way I could get it to work was to add some code to  views/includes/handlers.inc.

function build_join($select_query, $table, $view_query) {
  //add this code
  if(isset($this->extra)){
        $this->extra = $this->definition['extra'];
     }

Without that, no matter how I set the extra, I couldn't get it to appear in the join.

Hi,

as Pete said, there are options to select, which Adress Type to use (see screenshot attached). You should find these options when you click on an address field in your view.

We are running Drupal 7 and CiviCRM 4.4.4 - however, it should also be availabe for other versions.

Best Regards
Fabian