$view = new view(); $view->name = 'civi_and_og_fz'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_contact'; $view->human_name = 'civi and og fz'; $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['query']['options']['distinct'] = TRUE; $handler->display->display_options['query']['options']['pure_distinct'] = TRUE; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'id' => 'id', 'gid' => 'gid', 'display_name' => 'display_name', 'title' => 'title', 'membership_type' => 'membership_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, ), 'gid' => 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, ), 'title' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'membership_type' => array( 'sortable' => 1, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); /* Relationship: CiviCRM Contacts: Drupal ID */ $handler->display->display_options['relationships']['drupal_id']['id'] = 'drupal_id'; $handler->display->display_options['relationships']['drupal_id']['table'] = 'civicrm_contact'; $handler->display->display_options['relationships']['drupal_id']['field'] = 'drupal_id'; /* Relationship: OG membership: OG membership from User */ $handler->display->display_options['relationships']['og_membership_rel']['id'] = 'og_membership_rel'; $handler->display->display_options['relationships']['og_membership_rel']['table'] = 'users'; $handler->display->display_options['relationships']['og_membership_rel']['field'] = 'og_membership_rel'; $handler->display->display_options['relationships']['og_membership_rel']['relationship'] = 'drupal_id'; /* 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: OG membership: Group ID */ $handler->display->display_options['fields']['gid']['id'] = 'gid'; $handler->display->display_options['fields']['gid']['table'] = 'og_membership'; $handler->display->display_options['fields']['gid']['field'] = 'gid'; $handler->display->display_options['fields']['gid']['relationship'] = 'drupal_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: Content: Title */ $handler->display->display_options['fields']['title']['id'] = 'title'; $handler->display->display_options['fields']['title']['table'] = 'node'; $handler->display->display_options['fields']['title']['field'] = 'title'; /* Field: CiviCRM Member: Membership Type */ $handler->display->display_options['fields']['membership_type']['id'] = 'membership_type'; $handler->display->display_options['fields']['membership_type']['table'] = 'civicrm_membership'; $handler->display->display_options['fields']['membership_type']['field'] = 'membership_type'; /* Filter criterion: OG membership: Group ID */ $handler->display->display_options['filters']['gid']['id'] = 'gid'; $handler->display->display_options['filters']['gid']['table'] = 'og_membership'; $handler->display->display_options['filters']['gid']['field'] = 'gid'; $handler->display->display_options['filters']['gid']['relationship'] = 'drupal_id'; $handler->display->display_options['filters']['gid']['operator'] = 'not empty'; $translatables['civi_and_og_fz'] = array( t('Master'), t('more'), t('Apply'), t('Reset'), t('Sort by'), t('Asc'), t('Desc'), t('Items per page'), t('- All -'), t('Offset'), t('« first'), t('‹ previous'), t('next ›'), t('last »'), t('Drupal User'), t('OG membership from user'), t('Contact ID'), t('.'), t(','), );