$view = new view(); $view->name = 'relationships_multiple_types_and_examples'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_contact'; $view->human_name = 'relationships multiple types and examples'; $view->core = 7; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Master */ $handler = $view->new_display('default', 'Master', 'default'); $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['access']['type'] = 'none'; $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '100'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['quantity'] = '9'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'id' => 'id', 'display_name' => 'display_name', 'display_name_1' => 'display_name_1', 'relationship_type' => 'relationship_type', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'id' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'display_name' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'display_name_1' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'relationship_type' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); /* Relationship: CiviCRM Contacts: CiviCRM Relationship (starting from Contact B) */ $handler->display->display_options['relationships']['relationship_id_b']['id'] = 'relationship_id_b'; $handler->display->display_options['relationships']['relationship_id_b']['table'] = 'civicrm_contact'; $handler->display->display_options['relationships']['relationship_id_b']['field'] = 'relationship_id_b'; $handler->display->display_options['relationships']['relationship_id_b']['relationship_type'] = array( 4 => '4', 5 => '5', 11 => '11', ); /* Relationship: CiviCRM Relationships: Contact ID A */ $handler->display->display_options['relationships']['contact_id_a_']['id'] = 'contact_id_a_'; $handler->display->display_options['relationships']['contact_id_a_']['table'] = 'civicrm_relationship'; $handler->display->display_options['relationships']['contact_id_a_']['field'] = 'contact_id_a_'; $handler->display->display_options['relationships']['contact_id_a_']['relationship'] = 'relationship_id_b'; $handler->display->display_options['relationships']['contact_id_a_']['required'] = TRUE; /* Field: CiviCRM Contacts: Contact ID */ $handler->display->display_options['fields']['id']['id'] = 'id'; $handler->display->display_options['fields']['id']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['id']['field'] = 'id'; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name']['id'] = 'display_name'; $handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 0; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name_1']['id'] = 'display_name_1'; $handler->display->display_options['fields']['display_name_1']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name_1']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name_1']['relationship'] = 'contact_id_a_'; $handler->display->display_options['fields']['display_name_1']['label'] = 'Related contact'; $handler->display->display_options['fields']['display_name_1']['link_to_civicrm_contact'] = 0; /* Field: CiviCRM Relationships: Relationship Type A-to-B */ $handler->display->display_options['fields']['relationship_type']['id'] = 'relationship_type'; $handler->display->display_options['fields']['relationship_type']['table'] = 'civicrm_relationship'; $handler->display->display_options['fields']['relationship_type']['field'] = 'relationship_type'; $handler->display->display_options['fields']['relationship_type']['relationship'] = 'relationship_id_b';