'nid', 'group' => 'Chado Analysis' ); $data['chado_analysis']['nid'] = array( 'title' => t('Analysis Node ID'), 'help' => t('The node ID for this analysis'), 'field' => array( 'handler' => 'views_handler_field_numeric', 'click sortable' => TRUE, ), 'filter' => array( 'handler' => 'views_handler_filter_numeric', ), 'sort' => array( 'handler' => 'views_handler_sort', ), ); // Note: No joins need to be made from $data['analysis']['table'] // Join the chado analysis table to analysis $data['chado_analysis']['table']['join']['analysis'] = array( 'left_field' => 'analysis_id', 'field' => 'analysis_id', ); // Join the node table to chado analysis $data['node']['table']['join']['chado_analysis'] = array( 'left_field' => 'nid', 'field' => 'nid', ); // Join the node table to analysis $data['node']['table']['join']['analysis'] = array( 'left_table' => 'chado_analysis', 'left_field' => 'nid', 'field' => 'nid', ); // Add relationship between chado_analysis and analysis $data['chado_analysis']['analysis_nid'] = array( 'group' => 'Analysis', 'title' => 'Analysis Node', 'help' => 'Links Chado Analysis Fields/Data to the Nodes in the current View.', 'real field' => 'analysis_id', 'relationship' => array( 'handler' => 'views_handler_relationship', 'title' => t('Chado => Analysis'), 'label' => t('Chado => Analysis'), 'real field' => 'analysis_id', 'base' => 'analysis', 'base field' => 'analysis_id' ), ); // Add node relationship to analysis $data['chado_analysis']['analysis_chado_nid'] = array( 'group' => 'Analysis', 'title' => 'Analysis Node', 'help' => 'Links Chado Analysis Fields/Data to the Nodes in the current View.', 'real field' => 'nid', 'relationship' => array( 'handler' => 'views_handler_relationship', 'title' => t('Chado => Node'), 'label' => t('Chado => Node'), 'real field' => 'nid', 'base' => 'node', 'base field' => 'nid' ), ); return $data; }